How do I insert a cell which changes value when clicked on

  • Thread starter Thread starter JohnRScott
  • Start date Start date
J

JohnRScott

I wnt to have cell in excel which changes from TRUE to FALSE when clicked on
and vice versa. Is this possible?
 
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.
 
1.Right click on the toolbar, from the popup select control box.
2.Select a command button from the control box on your sheet
3.Double click on the command button to open the code window and past
following codes

Code
-------------------

Private Sub CommandButton1_Click()
Sheet1.Range("A1").Value = Not CBool(Sheet1.Range("A1").Value)
End Sub

-------------------




Chris
 
Back
Top