Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Buttons
I like to know how to use a button in a spreadsheet (rather than having to
enter a value) that when clicked on would equal one (1) and have a default of zero. |
#2
|
|||
|
|||
Hi
put something like the following code behind the button: with activesheet.range("A1") .value=-(.value)+1 end with this toggles between 0 and 1 -- Regards Frank Kabel Frankfurt, Germany "DaveSunsation" schrieb im Newsbeitrag ... I like to know how to use a button in a spreadsheet (rather than having to enter a value) that when clicked on would equal one (1) and have a default of zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What happened to Subscript and Superscript Buttons in Excel? | Charts and Charting in Excel |