You can do this with DataValidation.

In the Allow box choose "List" and then in the "Source" either type in your
variables seperated by commas or enter the range that holds the list. This
can be a named range if the list is on another worksheet.

Hope this helps
Rowan

"Curt" wrote:

I am updating a Excel 2000 spreadsheet that displays a single cell to list
one of a number of verables. The cell, when clicked, displays a "down arrow"
box that then refers to the variables list from which to select. I need to
duplicate that function.