Is there a reason that you don't want to store the list on a worksheet?
Then you'd be able to create a much longer list. To use a list on a
different worksheet, you can name the list, as described he

http://www.contextures.com/xlDataVal01.html

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.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html