View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default How do I insert a cell which changes value when clicked on

No it isn't possible. You can do something close.

1) Create a button which executes VBA code. The code will check the value
of a cell for example "C1" and if the contents are "False" put a value of
"True there and vice versa.


"JohnRScott" wrote:

I wnt to have cell in excel which changes from TRUE to FALSE when clicked on
and vice versa. Is this possible?