Macro button and macro

Closed
san - 27 Aug 2009 à 04:11
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 29 Aug 2009 à 07:23
Hello,
Buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")

where to paste the above line to create macro button and how to procedd with macro,
Related:

1 response

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
29 Aug 2009 à 07:23
'First create the button and then
'put the above code a module in a procedure as shown below
Sub buttonName_Click
Buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")
End sub