Macro button and macro

Closed
san - Aug 27, 2009 at 04:11 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 29, 2009 at 07:23 AM
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,

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 29, 2009 at 07:23 AM
'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
0