how can I extend my drop-down box length to include all the list?

[sigeco]

I am wanting to be able to select a list and see all the choices, not just
the default of the first eight.

Any help?

 

[Biff]

Hi!

Use a combo box from the Forms toolbar. You can specify how many items to
display in the list.

Biff

 

[Gord Dibben]

You cannot extend a Data Validation drop-down above the 8 choices.

You can use a ComboBox of much greater height to get more in view.

See Debra Dalgleish's site for info on this.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

 

[sigeco]

Thanks, Biff!

I didn't think to use a combo box. It will work out fine

sigeco

 

[Biff]

You're welcome!

Biff

Thanks, Biff!

I didn't think to use a combo box. It will work out fine

sigeco