Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo Box Sizing .XLS

Status
Not open for further replies.

RonCT

Technical User
Dec 11, 2003
37
0
0
US
Is there a way to change the font in a combo box in Excel 97? Also, how do you make the combo box smaller? Right now I have it to the smallest size that Excel lets me when I right click on it. It is still too big for the form I am creating. Thanks!
 
I'm not sure I understand.

You should be able to set the font property of the combobox using the Properties window.

The same goes for the size.

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?
 
If same as Excel 2000...

To change Font
Right-click the text box
Choose Properties
Scroll down to Font
Select the desired font

To Resize
Group together the combo box and all the objects inside it. Now, when you drag a corner of the combo box to resize it, it should adjust accordingly.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top