You can have almost the same thing with a Data Validation pull-down.

One click on the cell will allow you to pick from a list of value.

See:

http://www.contextures.com/xlDataVal01.html
--
Gary''s Student - gsnu200835


"Ken G." wrote:

Is there a way of making a cell active so that it can have two values - say
"apples" and "oranges", and simply clicking on the cell will toggle between
the two values?