Ken G.;238945 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?

Hi,
you'll most likely need VBA for this.

Good luck


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=66715