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
 
Back
Top