Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle cell value
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle cell value | Excel Discussion (Misc queries) | |||
Can I toggle the value of a cell by clicking directly on the cell? | Excel Discussion (Misc queries) | |||
Linking a cell to a toggle switch | Excel Programming | |||
Toggle a cell | Excel Programming | |||
Toggle True/False in a cell | Excel Programming |