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

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

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=562339

"Whoopa" wrote...
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

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