ListBox (maybe?) ... If so, how?

[Ken]

Excel 2000 ... Earlier today I saw a spread sheet that
had what appeared to be a Filter Switch in a Cell.

When cell with switch selected ... switch listed 2 values
to choose from (Y or N) ... In addition, as different
cells (requiring same Y or N value) were selected the
switch moved to selected cell.

Above said ... how is this all accomplished as I wish to
replicate this capability on another spread sheet?

Thanks ... Kha

 

[David Benson]

Ken,

What you describe sounds like Data Validation. Check out "Designate valid
cell entries" in Excel Help.


David

 

[Debra Dalgleish]

You can use Data Validation to create a dropdown list in a cell. There
are instructions in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html

 

[Ken]

-----Original Message-----
You can use Data Validation to create a dropdown list in a cell. There
are instructions in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.