Is it possible to change the font and font size for a forms control
drop down list (not an ActiveX control) ?



Exceluser

On 10/25/2010 6:22 PM, exceluser wrote:
> Is it possible to change the font and font size for a forms control
> drop down list (not an ActiveX control) ?
>
>
>
> Exceluser

Do you mean that you added a Combobox to a Userform, and you want to
change the font family and font size of the text in the Combobox? If so
right click on the Combobox, select Properties in the context menu, then
in the Properties window click on the three dots at the right side of
the right column where Font is displayed in the left column. Is this
what you're looking for?

http://en.allexperts.com/q/Excel-105...pdown-List.htm

Mike

Mike,

Thanks for responding.

In Excel 2007, I added a Forms Control Combo Box. When selected,
the Combo Box is specified as Drop Down 2.

However, the font is too small.

I would use the ActiveX Combo Box, but when a selection is chosen
from the drop down list and another cell is selected, the selected
value in the drop down list appears bolded.

The font properties only seem to apply when the drop down list is
dropped down.

If the ActiveX Combo Box were to be used, is there a way to prevent
the selection from displaying in bold.



Exceluser

Mike,

I would post the worksheet, but the spreadsheet is over 10 MB and
has too many external dependencies - you'd basically see a lot of
cells with error results.

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.




Exceluser

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