ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i change the font size in a combo box? (https://www.excelbanter.com/excel-worksheet-functions/39794-how-do-i-change-font-size-combo-box.html)

nkruppa

how do i change the font size in a combo box?
 
I need to change the font size in a combo box that I created. Excel will not
let me change it in any way. The font is 10 pt. and I need it to be 15 pt.
to be visible on the sheet.
Is there anyone out there that can help me with this?
SOS,
Niki

Debra Dalgleish

If it's a data validation dropdown list, you can't change the font size.
There are a couple of workarounds he

http://www.contextures.com/xlDataVal08.html#Font

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.


nkruppa wrote:
I need to change the font size in a combo box that I created. Excel will not
let me change it in any way. The font is 10 pt. and I need it to be 15 pt.
to be visible on the sheet.
Is there anyone out there that can help me with this?
SOS,
Niki



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



All times are GMT +1. The time now is 07:38 AM.

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