Size of drop down in validation list

  • Thread starter Thread starter dhstein
  • Start date Start date
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.
 
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...
 
Back
Top