×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Changing Font in Excel Combo Box

Changing Font in Excel Combo Box

Changing Font in Excel Combo Box

(OP)
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
 

RE: Changing Font in Excel Combo Box

   
"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

RE: Changing Font in Excel Combo Box

(OP)
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

RE: Changing Font in Excel Combo Box

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.

RE: Changing Font in Excel Combo Box

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."hammer

RE: Changing Font in Excel Combo Box

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

RE: Changing Font in Excel Combo Box

(OP)
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

RE: Changing Font in Excel Combo Box

(OP)
fumei, ok thanks for confirming.

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

RE: Changing Font in Excel Combo Box

(OP)
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 :(

RE: Changing Font in Excel Combo Box

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

RE: Changing Font in Excel Combo Box




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,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Changing Font in Excel Combo Box

Hacktastic,

I said this:

Quote:


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.

RE: Changing Font in Excel Combo Box

Uh Skip?

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

What makes you say that?  The OP stated:

Quote:

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...

Quote (ME):

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

RE: Changing Font in Excel Combo Box

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close