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
Subscribe to:
Post Comments
(Atom)
No comments:
Post a Comment