Inserting a combo box

  • Thread starter Thread starter Eric Blitzer
  • Start date Start date
E

Eric Blitzer

Excel 2000

I want to create a combo box in sheet1 that will list the
values in sheet2!a1:a7 and let the user select one of the
items to populate the combo box

Thanks

Eric
 
Highlight the cells on Sheet 1 (a1:a7), click inside the "Name Box" (the one
with the cell reference in it), type "MyList" (without the quotes), press
ENTER, switch to Sheet 2 and click in the cell where you want the dropdown,
click "Data", "Validation", click the dropdown arrow and select "Allow
List", in the "Source" box type "=MyList" (without the quotes). Click "OK"
to accept. Click the AutoFill handle at the bottom right of your cell and
drag down to as many cells as you want to copy the dropdown list to.

Bill Foley
www.pttinc.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I Keep a Combo Box "Focused" on difrferent cells. 5
combo box 1
Combo Box Limits Data Entry 1
About Fuctions 1
How do I create a combo box that is tied to another combo box? 2
How to combine Combo Box function with Vlookup function 2
Populate a combo Box 1
using vlookup with combo box 4

Back
Top