Size of drop down in validation list

D

dhstein

I have a validation list which contains about 50 elements. The drop down
only shows 9 entries which I can then scroll through. Is there a way to get
the drop down to show more entries? There is nothing below the cell which
contains the validation list. Thanks for any help on this.
 
P

Paul

There is no way to change the number of entries shown in a dat
validation drop-down list. I believe you can do so with a ComboBo
control (i.e. from the Developer toolbar), but then additional code ma
be required to validate entries.



I have a validation list which contains about 50 elements. The dro
down
 
D

dhstein

Thanks Paul

Paul said:
There is no way to change the number of entries shown in a data
validation drop-down list. I believe you can do so with a ComboBox
control (i.e. from the Developer toolbar), but then additional code may
be required to validate entries.




I have a validation list which contains about 50 elements. The drop
down


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=193089

http://www.thecodecage.com/forumz

.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
drop box/data validation help 0
Space at end of multi page list to accommodate new entries 1
Filtered drop down list 2

Top