How to set the amount of values visible when open a combo box?

[AA Arens]

How to set the amount of values visible when open a combo box?
and
How to have a default value highlighted when opened as always the top
of the list is visible.

Bart
Excell 2003

 

[jkend69315]

Is your combobox in a userform or on a worksheet?

 

[AA Arens]

On a worksheet. With data from another sheet. The combo is set via Menu

Data > Validation > List.

Bart

 

[Debra Dalgleish]

The data validation dropdown is limited to 8 rows, and can't be changed.

If you can use macros, there's a sample file here that provides a
combo box from which you can select one of the values. In a combo box, you
can set the number of rows in the dropdown list. There are instructions
here:

http://www.contextures.com/xlDataVal11.html

The data validation list will open with the cell's entry selected in the
dropdown list, so you could type the default value in the cell. Then,
users can select a different item if necessary.