Select one variable from a list of variables by clicking one cell
 

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.

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.

Hi, Curt. Try the instructions he
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Curt" wrote in message
...
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.