View Single Post
 
Old 08-27-2011, 07:28 AM
lukewarmbeer lukewarmbeer is offline Windows XP Office 2010 (Version 14.0)
Novice
 
Join Date: Jul 2010
Posts: 3
lukewarmbeer is on a distinguished road
Default 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?
Reply With Quote