Hi All,
Can I use in cells data validation results of user-defined function?
I have an UDF that gets Custom Fill List contents by custom fill list index. Let it named FillList, and a result is an array of strings
Then I trying to enter Data Validation source as =FillList(1). It do not works.
Ok, I create name, for example, "first_list", then in name source I enter =FillList(1). Name created.
Then, when I try to enter =first_list as source for data validation, it fails (of course)
Is there are any other ways to use an array was got as result of UDF in Data Validation rules?
Or here may be other way to use custom fill list as data validation rule?
Thanks!
--
Maxim
Bookmarks