Formatting Combo Box Text

by Allen Wyatt
(last updated July 13, 2016)

You can use the Forms toolbar to add a combo box to your worksheet, as has been discussed in other issues of ExcelTips. You can control many attributes of the combo box (right-click it and choose Format Control), but you cannot change the attributes of the font used to display information in the combo box. This seems to be an odd oversight on the part of Microsoft, but it has been that way since the earliest days of the Forms controls.

If you want greater control over how the combo box looks, then you will need to skip the Forms controls and instead add one from the Control Toolbox. You can display this toolbox by choosing Toolbars from the View menu, and then choosing Control Toolbox.

The controls available in the Control Toolbox look very similar to the Forms controls. The Control Toolbox controls, while they have the same names as the Forms controls, are quite different. For instance, you can place a combo box, but it looks a bit different than the one you place using the Forms controls. In addition, you can select a newly placed combo box and then click Properties to see all the attributes you can change—there are quite a few more of them when you add a combo box in this manner.

So what differences are there between the two ways of adding a combo box? Besides appearance and a richer set of properties, there isn't a whole lot of difference. There is one operational difference—you can insert a combo box from the Forms controls onto a chart sheet, but you cannot do so from the Control Toolbox.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2387) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Storing Building Block Entries with a Document

Building Blocks can provide quite a bit of flexibility and power in a document. If you want to share Building Blocks with ...

Discover More

Replacing Random Text with Your Own Text

Word includes a little-known function that allows you to put "filler text" into your document. If you want this function to ...

Discover More

Determining How Many Styles are Available

Got a macro that processes or uses styles? You definitely need to know how many styles Word has available in the document. ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Displaying Zeros

There are times when displaying zero values in a worksheet (especially if there are lots of them) can be distracting from the ...

Discover More

Hiding Rows Based on a Cell Value

This tip contains a macro to hide rows that contain data you don't want to see.

Discover More

Removing All Formatting

Getting rid of formatting from a cell or group of cells can be done using several different techniques. This tip describes ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 + 8?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share