Macro button and macro

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
'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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!