ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Font for Combo Box Control (https://www.excelbanter.com/excel-discussion-misc-queries/141138-font-combo-box-control.html)

James C.

Font for Combo Box Control
 
Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to
figure out how to change the font size within the box. When I right click and
go into the control properties it doesn't give me an option to change the
font. If I select the control and then go up to the font size the font is
greyed out.

This seems like it would be very simple to do, but I can't figure it out.
Any help would be appreciated.

Thanks

FSt1

Font for Combo Box Control
 
hi,
in design mode, right click the control. Scroll down to and click into the
box to the right of the word font. A small square will appear in the box.
click it and the font properties dialog box will appear.

controls have their own fonts. the fonts on the tool bar are for sheet fonts.

Regards
FSt1

"James C." wrote:

Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to
figure out how to change the font size within the box. When I right click and
go into the control properties it doesn't give me an option to change the
font. If I select the control and then go up to the font size the font is
greyed out.

This seems like it would be very simple to do, but I can't figure it out.
Any help would be appreciated.

Thanks


James C.

Font for Combo Box Control
 
When I right click on the control the options that it gives me a
- Cut
- Copy
- Grouping
- Order
- Assign Macro
- Format Control

That is it, within format control there is no place to select Font? Am I
missing something?

"FSt1" wrote:

hi,
in design mode, right click the control. Scroll down to and click into the
box to the right of the word font. A small square will appear in the box.
click it and the font properties dialog box will appear.

controls have their own fonts. the fonts on the tool bar are for sheet fonts.

Regards
FSt1

"James C." wrote:

Hi, I placed a drop-down box (Combo Box) on one of my sheets and am trying to
figure out how to change the font size within the box. When I right click and
go into the control properties it doesn't give me an option to change the
font. If I select the control and then go up to the font size the font is
greyed out.

This seems like it would be very simple to do, but I can't figure it out.
Any help would be appreciated.

Thanks


Peo Sjoblom

Font for Combo Box Control
 
You need to use the combobox from the control toolbox toolbar, not the forms
toolbar. Right click and select properties and you will see the font option
there

--
Regards,

Peo Sjoblom


"James C." wrote in message
...
When I right click on the control the options that it gives me a
- Cut
- Copy
- Grouping
- Order
- Assign Macro
- Format Control

That is it, within format control there is no place to select Font? Am I
missing something?

"FSt1" wrote:

hi,
in design mode, right click the control. Scroll down to and click into
the
box to the right of the word font. A small square will appear in the box.
click it and the font properties dialog box will appear.

controls have their own fonts. the fonts on the tool bar are for sheet
fonts.

Regards
FSt1

"James C." wrote:

Hi, I placed a drop-down box (Combo Box) on one of my sheets and am
trying to
figure out how to change the font size within the box. When I right
click and
go into the control properties it doesn't give me an option to change
the
font. If I select the control and then go up to the font size the font
is
greyed out.

This seems like it would be very simple to do, but I can't figure it
out.
Any help would be appreciated.

Thanks




FSt1

Font for Combo Box Control
 
Thanks Peo. I missed that.

regards
FSt1

"Peo Sjoblom" wrote:

You need to use the combobox from the control toolbox toolbar, not the forms
toolbar. Right click and select properties and you will see the font option
there

--
Regards,

Peo Sjoblom


"James C." wrote in message
...
When I right click on the control the options that it gives me a
- Cut
- Copy
- Grouping
- Order
- Assign Macro
- Format Control

That is it, within format control there is no place to select Font? Am I
missing something?

"FSt1" wrote:

hi,
in design mode, right click the control. Scroll down to and click into
the
box to the right of the word font. A small square will appear in the box.
click it and the font properties dialog box will appear.

controls have their own fonts. the fonts on the tool bar are for sheet
fonts.

Regards
FSt1

"James C." wrote:

Hi, I placed a drop-down box (Combo Box) on one of my sheets and am
trying to
figure out how to change the font size within the box. When I right
click and
go into the control properties it doesn't give me an option to change
the
font. If I select the control and then go up to the font size the font
is
greyed out.

This seems like it would be very simple to do, but I can't figure it
out.
Any help would be appreciated.

Thanks






All times are GMT +1. The time now is 05:55 AM.

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