Font Size in Drop Down List

I have a drop down list where I want to change the Font Size. I have tried
changed it in the cells where the data resides and also in the cells where
you have the drop down list and neither way increase the Font Size. I am
sure it is something very simple that I am forgetting. Hope someone has the
answer.

Mindie

What type of drop-down list?

Data Validation? Font size cannot be changed although you can use Zoom to
make the whole sheet larger.

See Debra Dalgleish's site for workarounds.

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


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 12:40:02 -0700, Mindie <Mindie@discussions.microsoft.com>
wrote:

>I have a drop down list where I want to change the Font Size. I have tried
>changed it in the cells where the data resides and also in the cells where
>you have the drop down list and neither way increase the Font Size. I am
>sure it is something very simple that I am forgetting. Hope someone has the
>answer.

Yes it is Data Validation. Problem is that I do not want to change the whole
sheet, just what is in the drop-down list.

"Gord Dibben" wrote:

> Mindie
>
> What type of drop-down list?
>
> Data Validation? Font size cannot be changed although you can use Zoom to
> make the whole sheet larger.
>
> See Debra Dalgleish's site for workarounds.
>
> http://www.contextures.on.ca/xlDataVal08.html#Font
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 10 Jul 2006 12:40:02 -0700, Mindie <Mindie@discussions.microsoft.com>
> wrote:
>
> >I have a drop down list where I want to change the Font Size. I have tried
> >changed it in the cells where the data resides and also in the cells where
> >you have the drop down list and neither way increase the Font Size. I am
> >sure it is something very simple that I am forgetting. Hope someone has the
> >answer.
>
>

Then you will have to go the Combo-box route.

Did you check out Debra's site?

I'll direct you to another of her pages which shows how to use a Combo-box.

Note:VBA coding required with this method.

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


Gord Dibben MS Excel MVP


On Mon, 10 Jul 2006 15:04:01 -0700, Mindie <Mindie@discussions.microsoft.com>
wrote:

>Yes it is Data Validation. Problem is that I do not want to change the whole
>sheet, just what is in the drop-down list.
>
>"Gord Dibben" wrote:
>
>> Mindie
>>
>> What type of drop-down list?
>>
>> Data Validation? Font size cannot be changed although you can use Zoom to
>> make the whole sheet larger.
>>
>> See Debra Dalgleish's site for workarounds.
>>
>> http://www.contextures.on.ca/xlDataVal08.html#Font
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Mon, 10 Jul 2006 12:40:02 -0700, Mindie <Mindie@discussions.microsoft.com>
>> wrote:
>>
>> >I have a drop down list where I want to change the Font Size. I have tried
>> >changed it in the cells where the data resides and also in the cells where
>> >you have the drop down list and neither way increase the Font Size. I am
>> >sure it is something very simple that I am forgetting. Hope someone has the
>> >answer.
>>
>>