Changing Font in Excel Combo Box

[Hacktastic]

Hello,

I need to change the font size within a combo box in excel. Not sure this is the right forum but any help would be greatly appreciated.

this is not the active x combo box, this is the standard combobox in excel 2007.

Thanks

 

[Andrzejek]

"this is not the active x combo box, this is the standard combobox in excel 2007."

By 'standard combobox' - do you mean a combobox on a UserForm in Excel? If so, go to VBA editor (Alt-F11) and change the Font property of the combo box on the UserForm.

Have fun.

---- Andy

 

[Hacktastic]

Hi andy,

negative, on that. the combo box comes from straight developer tab > insert > then selecting combo box. I did not use VB to create a custom userform.

Chris

 

[GlennUK]

Hi Hacktastic,

from what I remember ( I don't have access to Excel 2007 today ), there are 2 groups of objects that you can insert from Developer Tab > Insert, one being the Forms Toolbar objects, and the other being the Control Toolbox objects ... make sure that you are inserting the Control Toolbox ComboBox, as this has properties that you can change, including Font.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Scott24x7]

Hacktastic,
What Andrzejek says is correct. He doesn't mean you are using a VB object, but that you have to use the "Visual Basic" button in the ribbon in order to edit the font of this "standard object". Excel does not treat this as an "in cell" item, so you have to treat it as a "free floating" object. First you need to enable the "Developer" tab on your Excel file, if you haven't done so already.
(Go to Options, customize Ribbon, and check the "Developer" box on to see it appear in your ribbon).
Then, click on the icon "Visual Basic", and you will find properties for that object. Set the Font property to what you want it to be.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[fumei]

It seems to me that it is a Forms control, in which case, no you can not change the font.

If it is a Controls control, then yes you can.

Simple enough to answer.

Go into Design Mode. Right click the control. If you get View Code as a possible item, then it is a Controls control, and yes you can change the font.

If you do not get View Code as a possible item, then no youi can not change the font.

Gerry

 

[Hacktastic]

Hi scott,

I put in the combo box from the developer tab. Please test this as it does not work.

From the developer tab, create a new combo box(non active x). Then put some dummy data in, then select it with right click so its selected (white little circles on the corners) but not activity the pulldown. then hit visual basic.

It takes me to the sheet page in VB with nothing in it.

Thanks
Chris

 

[Hacktastic]

fumei, ok thanks for confirming.

next question is , how do i make it a control control

 

[Hacktastic]

actually Fumei, ignore the previous post,

I can select the drop down, and it says view code, which takes me to vb on :

Sub DropDown1_Change()

End Sub


but I cant see anywhere the place to modify the font

 

[fumei]

Ok, if that is the case, it IS an ActiveX control (evem though you state it is non-activex...sorry, but you are incorrect).

In which case, instead of right click-->View Code, right click-->Properties (Font is a property, yes?). Find Font, and click in the box beside it; you will see a "..." dropdown at the far right of the box. Click that and select a Font/Font Size and....VOILA!

This is standard for all ActiveX controls.

Gerry

 

[SkipVought]

Gerry,

It IS a MS Forms Control object and NOT an ActiveX Object.

The PROPERTIES for these controls, have no font property.

Hacktastic,

If you need to control the font, then use an ActiveX Control.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

Hacktastic,

I said this:

Hi Hacktastic,from what I remember ( I don't have access to Excel 2007 today ), there are 2 groups of objects that you can insert from Developer Tab > Insert, one being the Forms Toolbar objects, and the other being the Control Toolbox objects ... make sure that you are inserting the Control Toolbox ComboBox, as this has properties that you can change, including Font. Cheers, Glenn.

... i.e. an ActiveX control.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[fumei]

Uh Skip?

"It IS a MS Forms Control object and NOT an ActiveX Object."

What makes you say that? The OP stated:

I can select the drop down, and it says view code, which takes me to vb on :

Sub DropDown1_Change()

End Sub

If it is a Forms, then they are not going to get View Code, are they? Not the _Change event as the default code view. Are they?

So, again, why are you insisting it is Forms control?

As for what you can do about font...

It seems to me that it is a Forms control, in which case, no you can not change the font.

If it is a Controls control, then yes you can.

I believe Glenn has also dealt with this. We are beating a dead horse here.

Identify it:

Controls control right click - View Code an option
Forms control right click - View Code NOT an option



What you can do with that information:

Controls toolbar - yes you can change font
Forms toolbar - no you can not change font



Gerry

 

[Hacktastic]

hi team,

you are right, forms toolbar has no control to change the font.

ended up using the active x control ( which was surprisingly easy) which has the font control. I really all your help.

Chris