Vladimir,
I'm not sure how you will be using this but it is easy to validate with a
custom combobox and the matchfound property
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Vladimir" wrote:

Hello John,

Thank you for the prompt reply. I will try the idea with custom
validation Combobox.

I noticed another interesting thing. If I just put all the values in a
column and then choose Validation : List and enter A1 : A21 as source,
everything is ok.

However, if I try to put all the data in the "Source" string directly
using "," as a separator, Excel doesn't allow me to enter more than ca.
220 characters...

Vladimir

John Bundy wrote:
I just put 50,000 in one and they all showed up, Excel 2003 though. Can you
just make a custom validation combobox?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.