Display more than 8 lines in an Excel dropdown box

B

Brettjg

Using Data Validation I can only get the drop-down box to display a maximum
of 8 lines, otherwise I have to use the scroll bar at the side to see the
other entries. Is there any way to set it so that it displays 12 or 15 lines
without having to scroll. The problem being that if the cell was blank to
start with the dropdown goes to the first entry after the last non-blank.
 
L

Leith Ross

Hello Brettjg,

Not possible using Data Validation. You can do it by placing a Forms
Toolbar Drop Down or Controls Toolbox ComboBox (ActiveX control) on the
worksheet and writting the macro code to do both the validation and
extending the number drop down of lines.

Sincerely,
Leith Ross
 
P

paul

you dont ned a macro to conrol a forms toolbar combo.The number of lines is a
property you can adjust in the format control menu when you right click on
the combo box.To make a forms combo box functional you need to use an index
or choose formula using the cell link to choose from your list
 
P

paul

its always tough to find the "help" for the forms combo box so heres a peek
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.

Combo box properties

Input range Reference to the range containing the values to display in
the drop-down list.

Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.

For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:

=INDEX(D10:D15,C1)
i use choose(c1,d10.d11,d12,d13,d14,d15)
 
Top