Inserting a combo box

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
 
P

PTT, Inc.

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
 
Top