Drop down box font size

  • Thread starter Thread starter Francis Hookham
  • Start date Start date
F

Francis Hookham

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
 
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

--

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
 
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
 
Back
Top