Format Font Size in Combo Box List
Is it possible to format the font size of the items in a combo box list? I have the combo box in a small cell and the font needs to be smaller in order to be able to read the text. I don't know if this would be changed from the VB macro. (I'm a newbie at this)!
Here is what I have:
Private Sub ComboBox1_Change()
ComboBox1.ColumnCount = 1
'Load data into ComboBox
ComboBox1.List() = Array("Finance", "Growth", "People", "Quality", "Service")
End Sub
Maybe there is another way. Any suggestions?
|