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. |
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. |
All times are GMT +1. The time now is 01:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com