Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

Changing Font Properties in a combo box

Posted by Tony H on August 01, 2001 4:01 AM
Hi All,

Simple question for you guru's...

Got my combox with all it's list working fine, but the font is stuck in Arial 8pt, how do I change this, different font sizes & colours ?

Also is it possible to have an "onselectable seperater" in a combo list ?

Thanks All!


Re: Changing Font Properties in a combo box

Posted by Jim on August 01, 2001 7:25 AM
Tony,
If i understand you correctly,in your combobox
properties scroll to "Font" click button for font
options
Jim


Re: Changing Font Properties in a combo box

Posted by Tony H on August 01, 2001 3:11 PM
Thanks for the reply Jim,

I'm "right clicking" on my combo box selecting Properties but the only options presented are moving and sizing with or without cells, I'm obviously looking in the wrong place but it's got me beat!

Cheers,

Tony


Re: Changing Font Properties in a combo box

Posted by Jim on August 02, 2001 5:38 AM
Tony,
Keypress Alt,F11
Click on Project Explorer
Click on Forms
Scroll down to your UserForm and Dbl Click
Scoll the Properties window to "Font"
CLick on "Font" the button and make your changes
Jim


Re: Changing Font Properties in a combo box

Posted by Tony H on August 02, 2001 2:59 PM
Thanks for the reply Jim,

My fault for not supplying all info, I'm not using a form, just a combo box that sits on a worksheet that links to a column of cells that supplies the combo box list, on selection I'm using a macro to navigate the user to a specific worksheet. I tried your fix and was unable to make it work. Thanks for your patience, appreciate your help!

Cheers,

Tony ,


Re: Changing Font Properties in a combo box

Posted by Ivan F Moala on August 03, 2001 12:56 AM
You are using the combobox avail from the Forms toolbar.
Suggest you use the Combobox avail from the control
toolbox = ActiveX control and therefore has it's
properties and events avail to program eg Fonts etc

HTH

Ivan


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.