Thread: Toggle a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad K. Brad K. is offline
external usenet poster
 
Posts: 41
Default Toggle a cell

I've tried several methods but can't quite figure it out. How can I write
the code so that when I click on a cell within a column it will toggle it
(i.e. if blank, put an "X" value or if it has an "X" value it will leave it
blank).
I want this to happen whether I click on the active cell or on a new cell
within the column.
Also, how do I do this if it requires a double click.
Thanks,
Brad