Combo box in Microsoft Excel

5 pts.
Tags:
Excel 2007
Microsoft Excel
Microsoft Excel ComboBox
How do I link numeric values to word choices in my combo box? I have tried If Then's for if you pick a certain choice it = a certain number, but I'm stuck! Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Simply append the beginning with a number then a period like

  1. First choice: To add a combo box in Excel 2007, click the Developer tab, click Insert, and then click Combo Box in the Form Controls section.
  2. Create an object that covers cells B2:E2.
  3. Right-click the combo box, and then click Format Control. Enter the following information, and then click OK:
  4. To specify the range for the list, type H1:H20 in the Input range box.
  5. To put a number value in cell G1 (depending on which item is selected in the list), type G1 in the Cell link box. Note The INDEX formula uses the value in G1 to return the proper list item.
  6. In the Drop down lines box, type 10. This entry determines how many items will be displayed before it is necessary to use a scroll bar to view the other items.

Note The 3-D shading check box is optional; it adds a three-dimensional look to the drop-down or combo box.
The drop-down box or combo box should display the list of items. To use the drop-down box or combo box, click any cell so that the object is not selected. When you click an item in the drop-down box or combo box, cell G1 is updated to a number indicating the position in the list of the item selected. The INDEX formula in cell A1 uses the number to display the item’s name.

This and more can be found on Microsoft’s website here.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following