how do set up a drop-down dialog box that allows users to select .

[vikingcowboy]

how do I allow a user to select from a drop down select box, and return 1
value from a list of indefinite length that is on another sheet.

 

[Gord Dibben]

You could use a Data Validation drop-down lsit.

For instructions on creating DV drop-downs and dynamic list ranges see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html for the basics.

http://www.contextures.on.ca/xlNames01.html#Dynamic for creating dynamic
ranges.

What the heck........browse through all her info on DV from first link above.

Gord Dibben Excel MVP