ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combo Box Font (https://www.excelbanter.com/excel-worksheet-functions/22427-combo-box-font.html)

Luther Gunter Jr.

Combo Box Font
 
How do I change a Combo Box font size?



Fadi Chalouhi

you can do it through the VBE editor :
- right click on the ComboBox
- in the properties box, select Font
- click on the "box with dots" that appears in the right-side of the
Font edit box.
- modify the font format there.

Alternatively, you can do this through VBA using
UserForm1.ComboBox1.Font.Size = ...

HTH

Fadi
www.chalouhis.com/XLBLOG


Debra Dalgleish

If it's a combobox from the Control toolbox, you can change the font
size by switching to Design view, opening the Properties window, and
changing the Font properties.

If it's a combobox from the Forms toolbar, you can't change the font size.



Luther Gunter Jr. wrote:
How do I change a Combo Box font size?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com