display a drop menu with options.

[melawaisi]

What I am trying to do is to display in a box a list of options to allow
the user to define exactly what they would like to view, for example,
one colum defines color, I would like to have some kind of drop menu
with all the colors and an option to display all colours

 

[Dave Peterson]

It kind of sounds like you have two dropdowns. The second is dependent on the
first.

If this is close to true, you may want to look at Debra Dalgleish's site. She
has some notes about data|Validation at:
http://www.contextures.com/xlDataVal02.html

And a way to create a name for a dynamic range at:
http://www.contextures.com/xlNames01.html#Dynamic