How can I add drop-down box in Excel 2002?

[Guest]

Hi!
I have a nice spreadsheet going, with a lot of neat formulas
and such, making it easy for the user to see a lot of data.

But I'd like to make one particular cell contain a drop-down
selection box with a group of items listed elsewhere in the
workbook. (Later I'll want to add more such cells.)

I don't see anything in the Help topics about doing this.

Say the list of items is in MyWS_1!A1010 and I want the
dropdown box in MyMainSheet!B5. (Long-time programmer,
but almost no VB/VBA/etc.)

1) CAN it be done?

2) HOW can it be done? Pointers to relevant web-pages
would be welcome.

Thanks!
Mike

 

[Gord Dibben]

Mike

Use a Data Validation List drop-down.

See Debra Dalgleish's site for info and instructions.

http://www.contextures.on.ca/xlDataVal01.html

Note the use of a Named Range when list is on a separate worksheet.

http://www.contextures.on.ca/xlDataVal05.html

Gord Dibben Excel MVP

 

[Debra Dalgleish]

Instructions for naming a range are here:

http://www.contextures.com/xlNames01.html

And I think Gord misspelled "workbook" <g>

Note the use of a Named Range when list is on a separate worksheet.

http://www.contextures.on.ca/xlDataVal05.html

 

[Guest]

Thank you, sir! I'll pop over there and see what it's all about.

Thanks!
Mike

 

[Gord Dibben]

Thanks Debra.

Wrong link. I was thinking worksheet as Mike said within same workbook but
"many a slip 'twixt cup and lip.........."

Gord