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.
 
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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List (Drop Down) Not Showing 2
Drop down list 2
increase number of items shown in drop down list? 12
Drop Down List Contains the List Header Row 1
validation list 6
Data-Validation -List - Pick from a drop down menu 4
Double Drop-Down Validation in Excel 2007 1

Top