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.