MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you increase the font size in a combo box?


Posted by Mark Gravelle on November 09, 2001 3:33 PM

I am setting up a combo box as follows:

Cell A1 contains "Air"
Cell A2 contains "Ocean"
I select a combo box and "format control".
Then I select the Control Tab and select my input range "A1:A2" and my cell link "A3".

Here's my problem: My drop down menu now has "Air" and "Ocean" as the 2 possible selections, but you'd have to be a bloody eagle to read these! I can't for the life of me seem to find where I can increase the font size for these combo box labels. Anyone familiar with this?


Posted by Luke on November 09, 2001 3:39 PM

within code you can use this state ment, for instance when initializing your combobox.
Also you can use the propertybox and click on fonts where you can edit font type and size etc.
combobox1.Font.Size