How can a user view/use/comprehend anything more than a dozen or so dropdowns
??

If the second dropdown depends on the user's selection in the first
dropdown, then see the advice offered here

http://www.pcmag.com/article2/0,1759,1585456,00.asp


"UweVahrson" wrote:

I need some thousand dropdown fields (via validation function) in Excel. But
if I input too many fields I can't save the file. Seems the number of
dropdown fields is limited. How can I enlarge the number of allowed dropdown
fields? Can I change the setup anyway?

"Duke Carey" wrote in message
...
How can a user view/use/comprehend anything more than a dozen or so
dropdowns
??

He might have a thousand data entry boxes that all have the same DV applied
to them?

It may be that that's the case, Bob, but I thank my lucky stars I don't have
to use a tool requiring a thousand data entry points.

"Bob Phillips" wrote:


"Duke Carey" wrote in message
...
How can a user view/use/comprehend anything more than a dozen or so
dropdowns
??

He might have a thousand data entry boxes that all have the same DV applied
to them?

I'm with you there :-)

Bob


"Duke Carey" wrote in message
...
It may be that that's the case, Bob, but I thank my lucky stars I don't
have
to use a tool requiring a thousand data entry points.

"Bob Phillips" wrote:


"Duke Carey" wrote in message
...
How can a user view/use/comprehend anything more than a dozen or so
dropdowns
??

He might have a thousand data entry boxes that all have the same DV
applied
to them?