| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a cell which changes value when clicked on
I wnt to have cell in excel which changes from TRUE to FALSE when clicked on
and vice versa. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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 paste following codes Code:
Private Sub CommandButton1_Click()
Sheet1.Range("A1").Value = Not CBool(Sheet1.Range("A1").Value)
End Sub
Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers view different when clicked on cell | Excel Discussion (Misc queries) | |||
| How can I detect that an excel cell has been clicked | Excel Discussion (Misc queries) | |||
| HOW DO I GET AN X IN A CELL IN EXCEL TO COME & GO WHEN CLICKED | Excel Discussion (Misc queries) | |||
| How do I insert radio button to sum a cell when clicked | Excel Worksheet Functions | |||
| Insert Data when hyperlink is clicked | Excel Discussion (Misc queries) | |||
Linear Mode
