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 Data>Validation.

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 here:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Curt" <[email protected]> wrote in message
news:[email protected]...
> 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.