View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike S[_5_] Mike S[_5_] is offline
external usenet poster
 
Posts: 86
Default Can you change the font and font size for a forms control ?

On 10/28/2010 2:48 PM, exceluser wrote:
...When you make a selection in the drop down list, the font
appearance is correct.
But selecting another cell causes the selection in the drop down
list to switch to what looks like a very jaggy MS Sans Serif Bold
font.
In Excel 2007, inserting an ActiveX Combo Box on a blank worksheet
nets the same result.


Without seeing it it's hard to tell, how about setting the combobox font
properties in the Enter event? Will that correct it?

Private Sub ComboBox1_Enter()
'set font properties here
End Sub