ExcelBanter - Size of font in Forms Combo Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Size of font in Forms Combo Box (https://www.excelbanter.com/excel-discussion-misc-queries/144963-size-font-forms-combo-box.html)

Woody13

Size of font in Forms Combo Box

I'm putting a combo box in Excel that allows me to have three names and to
sellect one. However, the font in the drop down box is too small. How do I
increase it? Thx

mikerickson

The Properties window has a font property that will let you change the font name, size and bolding of the Combo Box. For run-time changes,

Code:

Userform1.ComboBox1.Font.Size=12

is the syntax.
Hope that helps.

Quote:

Originally Posted by Woody13 (Post 503596)

I'm putting a combo box in Excel that allows me to have three names and to
sellect one. However, the font in the drop down box is too small. How do I
increase it? Thx

Ian

Size of font in Forms Combo Box

There doesn't appear to be any way to adjust the size (or font) in the combo
box from the Forms toolbar. If you can use the one from the Control Toolbox,
this is much more configurable.

--
Ian
--
"Woody13" wrote in message
...
I'm putting a combo box in Excel that allows me to have three names and to
sellect one. However, the font in the drop down box is too small. How do
I
increase it? Thx

All times are GMT +1. The time now is 08:39 PM.