Combo box on a worksheet font change

SUSANVV · May 23rd, 2002, 01:36 PM

I have place a combo box on a worksheet using the Forms toolbar. The box is filled from a range. No matter what font I make the text in the range or how big I make the box I cannot change the font size. TIA for any ideas.

Sue

lenze · May 23rd, 2002, 01:55 PM

Instead of using the Combo from the Form Toolbar, use the one from the Control Toolbar. you can set the font under properties

Seti · May 23rd, 2002, 01:56 PM

Make sure the control toolbox toolbar is active, select design mode, select the combo box, select the properties icon from the control toolbaox, in the properties box, you can set the font and the font size by choosing "Font".

(Excel 2000, Win 2K)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 01:36 PM	#1
SUSANVV New Member Join Date: May 2002 Posts: 1	I have place a combo box on a worksheet using the Forms toolbar. The box is filled from a range. No matter what font I make the text in the range or how big I make the box I cannot change the font size. TIA for any ideas. Sue

May 23rd, 2002, 01:55 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Instead of using the Combo from the Form Toolbar, use the one from the Control Toolbar. you can set the font under properties

May 23rd, 2002, 01:56 PM	#3
Seti Board Regular Join Date: May 2002 Location: CT Posts: 2,895	Make sure the control toolbox toolbar is active, select design mode, select the combo box, select the properties icon from the control toolbaox, in the properties box, you can set the font and the font size by choosing "Font". (Excel 2000, Win 2K)