View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MjMullen MjMullen is offline
external usenet poster
 
Posts: 4
Default combo box 'disappearing' font

I have a spreadsheet with several embedded combo boxes (from controls
toolbox, not forms toolbox) which reduces it's font by a step each time that
it's selected. This applies to the entire list, which is being called from a
named range on a separate worksheet.

I've set the initial font size to 12, and it goes to 11, then 10, then 9,
then...

If I go into design mode and re-size the box, it re-sets - but the process
begins again. And I obviously don't want my users to have to mess with the
design.

I know of at least one instance where the opposite problem occurs - the font
grows to a size that just the top of the letters is showing on a fellow
programmer's sheet.

We're using Excel 2000 on XP pro OS.

Can anyone give me direction on what property / option to set to get a
stable size for the drop down list?