Where is combo box in excel 2007

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Related 8. Hot Network Questions. Question feed. Super User works best with JavaScript enabled. Accept all cookies Customize settings. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback?

The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon.

Pictures helped. In the screen shot below, there is a table named tblProducts. To create a named range with the product names:. If you enter this name in the combo box's ListFillRange property, the name will not be accepted -- the property will be cleared, and the list of names won't appear in the combo box drop down. To use this list in the combo box, you can create a second name, based on the first name:. Then, in the Combo Box, use the second name -- ProdListB -- in the ListFillRange property, and it will be accepted, because it is not directly based on a table.

When a selection is made in a combo box, you can display the selected item in a cell on the worksheet. Select or clear the "Ignore blank" check box, depending on whether you allow the cell containing the drop-down box to be left blank.

Make certain the "In-cell dropdown" check box is selected. Click the "Input Message" tab to display a message box when the cell of the drop-down box is clicked.

Make certain that the "Show input message when cell is selected" check box is selected and then type the "Title:" and "Input message:" that will appear in the message box. Click the "Error Alert" tab to display an error message if invalid data is entered into the drop-down box cell. Make certain that the "Show error alert after invalid data is entered" check box is selected.

To display a warning or information but not prevent invalid data from being entered, select either "Warning" or "Information" from the "Style" drop-down list box. To display a message and prevent invalid data from being entered, select "Stop" from the "Style" drop-down list box. Type the "Title:" and "Error message:" that you want to appear. Click "OK" to save the validation criteria and create the drop-down box. Program the box using VBA Code:. AddItem "Item Name" to add some items.

To do this, make sure you say to add the items when something happens. Yes No. Not Helpful 3 Helpful Right-click on the area where you want to add a new entry, then click on "Insert", then "New Row" in between two existing rows. Not Helpful 19 Helpful Simple: delete the row or column that contains the range and the drop down list vanishes.

Not Helpful 9 Helpful 3. Include your email address to get a message when this question is answered. By using this service, some information may be shared with YouTube. If a drop-down list entry is longer than the cell containing the drop-down list box, change the cell width to reveal the entire text.