can you change the length of a drop down box

W

Whoopa

Is it possible to change the length of a drop down box. For example you have
12 items to display as opposed to the default 8
 
M

Mallycat

right click on the control, select format Control, and there is
setting you can change for this.

Mat
 
B

Biff

Is it possible to change the length of a drop down box. For example you
have
12 items to display as opposed to the default 8
Click to expand...

Hi!

You can't change the number of items displayed in a data validation drop
down list.

You could use a combo box from the Forms toolbar instead. You can specify
how many items are displayed. A combo box is very similar to a drop down
list except that the combo box drop arrow is always visible. Another
difference is that with a drop down list the selection made is entered into
the cell that holds the drop down. With a combo box the selection made is
not entered into a cell but you can link a cell to the combo box and have
the linked cell display the selection made.

Biff
 
Top