Thread: how can I extend my drop-down box length to include all the list?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default how can I extend my drop-down box length to include all the list?
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

On Mon, 19 Jun 2006 17:15:01 -0700, sigeco
wrote:

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?

Reply With QuoteReply With Quote