Custom Drop Down Lists

[samprince]

Hoepfully this will be Uber qwick.

I have created myself a drop down list of possible options to enter into a cell.

There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8?

Also If you can change that can you change the size of text that appears in the drop down list?

And if you can do that, can you use logo pictures instead of text?

Super., Thanks.

[Marcelo]

right click, setup controls, change to more than 8 lines

hth
regards from Brazil
Marcelo

"samprince" escreveu:

>
> Hoepfully this will be Uber qwick.
>
> I have created myself a drop down list of possible options to enter
> into a cell.
>
> There are in total 24 options; default has see it so you can see only
> the first 8 and then scroll down for to se the others. Can you change
> this value of 8?
>
> Also If you can change that can you change the size of text that
> appears in the drop down list?
>
> And if you can do that, can you use logo pictures instead of text?
>
> Super., Thanks.
>
>
> --
> samprince
> ------------------------------------------------------------------------
> samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
> View this thread: http://www.excelforum.com/showthread...hreadid=563652
>
>

[Gord Dibben]

If you created the drop-down list using Data>Validation>List, the 8 lines and
the text size is default and cannot be changed.

Workarounds provided by Debra Dalgleish at

http://www.contextures.on.ca/xlDataVal08.html#Font


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 07:29:00 -0400, samprince
<[email protected]> wrote:

>
>Hoepfully this will be Uber qwick.
>
>I have created myself a drop down list of possible options to enter
>into a cell.
>
>There are in total 24 options; default has see it so you can see only
>the first 8 and then scroll down for to se the others. Can you change
>this value of 8?
>
>Also If you can change that can you change the size of text that
>appears in the drop down list?
>
>And if you can do that, can you use logo pictures instead of text?
>
>Super., Thanks.