Friday, November 19, 2010

How to change font in MS Excel 2007 Combo Box Form Controls?

I went to Developer%26gt;Controls%26gt;Insert%26gt;Form Controls%26gt;Combo Box and inserted the combo box. Right clicked on it, selected ';Form Control'; then Control tab to select ';Input range'; and ';Cell Link';. Combo box is working perfectly. But I want to change the font and font size, so I went to Properties tab but there's no option for font. Where can I change the font? Thanks...How to change font in MS Excel 2007 Combo Box Form Controls?
There are two types of controls in Excel. A ';Form'; control type and an ';ActiveX'; control type. Both types offer a Combo-box control. The difference in the two types is basically the ActiveX type is much more configurable.



To enable the ActiveX controls without warnings read this...

Enable or disable ActiveX controls in Office documents

http://office.microsoft.com/en-us/excel/



Note: unless you open a lot of Excel files from strangers, enabling the AxctiveX controls without warning is pretty safe.





Here is a very good article on AxctiveX vs Form controls and how to use them...

Forms Controls and ActiveX Controls in Excel

http://peltiertech.com/WordPress/forms-c

No comments:

Post a Comment