Drop down box font size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Francis Hookham - 16 Dec 2005 18:50 GMT

XL 2004 (Mac) Drop down box font size appears to be same as font used in the
sheet

When the same workbook is opened in XL 2002 (Windows), the 12pt Arial in the
sheet appears to be about 8pt in the drop down box

Anyway of controlling Drop down box font size?

Francis Hookham

Reply to this Message

Peo Sjoblom - 16 Dec 2005 19:36 GMT

Drop down box font sizeAre you talking about validation? If so in windows there is no way of changing it, Debra Dalgleish has a way using a macro that will zoom

http://www.contextures.com/xlDataVal08.html#Larger

the chance of getting more answers is probably greater if you stop posting in html, it's better to use plain text since there are so many different news readers

Signature

Regards,

Peo Sjoblom

XL 2004 (Mac) Drop down box font size appears to be same as font used in the sheet

When the same workbook is opened in XL 2002 (Windows), the 12pt Arial in the sheet appears to be about 8pt in the drop down box

Anyway of controlling Drop down box font size?

Francis Hookham

Reply to this Message

Francis Hookham - 17 Dec 2005 10:20 GMT

Many thanks Peo for your answer and for the tip about html - I have not been
aware of that as a prob before but it is sensible so I shall try to remember
to switch in future

Francis

> Are you talking about validation? If so in windows there is no way of changing
> it, Debra Dalgleish has a way using a macro that will zoom
[quoted text clipped - 17 lines]
>>
>> Francis Hookham

Reply to this Message