Hello everyone,
For most of you these questions will be easy, but for me it's kinda headache...
I am creating data validation, using vba.
1) How to define the number of possible entries, beforehand I am taking all the values. (because I do not want to see this moving column on my right)
2) For a data validation list, separator is comma. But if I am having this comma INSIDE my entries, excel understands it as a separator. How to avoid it, not getting rid of comma?
Thank you in advance.
For most of you these questions will be easy, but for me it's kinda headache...
I am creating data validation, using vba.
1) How to define the number of possible entries, beforehand I am taking all the values. (because I do not want to see this moving column on my right)
2) For a data validation list, separator is comma. But if I am having this comma INSIDE my entries, excel understands it as a separator. How to avoid it, not getting rid of comma?
Thank you in advance.
