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

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?

Hi!

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

Biff

"sigeco" <sigeco@discussions.microsoft.com> wrote in message
news:BB13088A-BA96-4AF9-BC30-AB29FCD8A8CD@microsoft.com...
>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?

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 <sigeco@discussions.microsoft.com>
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?

Thanks, Biff!

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

sigeco

"Biff" wrote:

> Hi!
>
> Use a combo box from the Forms toolbar. You can specify how many items to
> display in the list.
>
> Biff
>
> "sigeco" <sigeco@discussions.microsoft.com> wrote in message
> news:BB13088A-BA96-4AF9-BC30-AB29FCD8A8CD@microsoft.com...
> >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?
>
>
>

You're welcome!

Biff

"sigeco" <sigeco@discussions.microsoft.com> wrote in message
news:E227F33F-CAF2-44D2-A7BC-AEAD8B199D51@microsoft.com...
> Thanks, Biff!
>
> I didn't think to use a combo box. It will work out fine
>
> sigeco
>
> "Biff" wrote:
>
>> Hi!
>>
>> Use a combo box from the Forms toolbar. You can specify how many items to
>> display in the list.
>>
>> Biff
>>
>> "sigeco" <sigeco@discussions.microsoft.com> wrote in message
>> news:BB13088A-BA96-4AF9-BC30-AB29FCD8A8CD@microsoft.com...
>> >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?
>>
>>
>>