Drop-down box font size?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mommio2 - 17 Jan 2008 02:45 GMT

Hi,
Could anyone please tell me how to change the size of the text in a
drop-down box in Excel? Changing the font size in the list it is based on
does nothing. Any ideas? Thanks!
Mommio2

Reply to this Message

mommio2 - 17 Jan 2008 02:58 GMT

In case it makes a difference, it is Excel 2003. Thanks again!

Mommio2

> Hi,
> Could anyone please tell me how to change the size of the text in a
> drop-down box in Excel? Changing the font size in the list it is based on
> does nothing. Any ideas? Thanks!
> Mommio2

Reply to this Message

Dave Peterson - 17 Jan 2008 12:09 GMT

What did you use to make the dropdown?

Data|Validation
A dropdown from the Forms toolbar
A combobox from the Control toolbox toolbar

I'm guessing the first.

If I'm right, you could visit Debra Dalgleish's site for a work-around:
http://contextures.com/xlDataVal08.html#Larger

> In case it makes a difference, it is Excel 2003. Thanks again!
>
[quoted text clipped - 5 lines]
> > does nothing. Any ideas? Thanks!
> > Mommio2

Signature

Dave Peterson

Reply to this Message

T. Valko - 17 Jan 2008 03:37 GMT

See if this helps:

http://contextures.com/xlDataVal08.html#Font

Signature

Biff
Microsoft Excel MVP

> Hi,
> Could anyone please tell me how to change the size of the text in a
> drop-down box in Excel? Changing the font size in the list it is based on
> does nothing. Any ideas? Thanks!
> Mommio2

Reply to this Message

Dave Peterson - 17 Jan 2008 12:10 GMT

Oops. I should have scrolled down a bit to see your reply!

> See if this helps:
>
[quoted text clipped - 9 lines]
> > does nothing. Any ideas? Thanks!
> > Mommio2

Signature

Dave Peterson

Reply to this Message