Font size in dropdown list - Excel'07

[TBL3]

I'm having a hard time trying to adjust the font size inside the dropdown list.

I have made the font size of the entire worksheet larger, however, the font size inside the dropdown list wasn't being adjusted to the font size I wished for.

Any idea how to solve this issue?


Thanks,
tbl3

 

[SkipVought]

Hi,

Is your drop down a..
[tt]
1. ActiveX control
2. Forms control
3. Data Validation LIST
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TBL3]

Data Validation List

 

[xlbo]

Font size in teh list itself cannot be changed - ouput font size should be fine once selected

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

Make the font size of the entire sheet smaller, and zoom in a little, to make the drop-down font look bigger. ( I know it's not what you wanted to hear, but that's the easiest way to get towards what you are after )

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[TBL3]

Thanks for the suggestions.
But I think I'm going to try working with Combo Box functionalities and see if that would work.


Cheers,
tbl3