I've found a strange problem:

I have a validation list containing several releases (information like
1.1 1.3, 1.0.2 etc.)

However, for some reasons Excel doesn't show the entire list in the
drop-down menu
and limits the number of entries.

Is there any restriction for the length of the validation list? How
many characters can I enter there?

If so, don't you possibly know a workaround solutions for this problem?
My list can easily expend in the future.

Any advice is highly appreciated,

Vladimir Kornev

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.


"Vladimir" wrote:

I've found a strange problem:

I have a validation list containing several releases (information like
1.1 1.3, 1.0.2 etc.)

However, for some reasons Excel doesn't show the entire list in the
drop-down menu
and limits the number of entries.

Is there any restriction for the length of the validation list? How
many characters can I enter there?

If so, don't you possibly know a workaround solutions for this problem?
My list can easily expend in the future.

Any advice is highly appreciated,

Vladimir Kornev

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.

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.

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