Size of drop down in validation list
 

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.

Size of drop down in validation list
 

Replace Drop/Down with UserForm

Display Userform with double-click

http://boisgontierjacques.free.fr/fi...on/DVForm2.xls

JB

On 5 avr, 20:05, dhstein wrote:
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.