How to create a clickable button and macro in [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I am trying to create a button in an Excel worksheet that will continuously recalculate the formulas on a given sheet. I have seen a button in someone else's workbook that would display different text when the button was clicked (Update On/Update Off).

Any assistance with both creating the button and the macro for this would be greatly appreciated!

Thank you,
Jeff

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
buttonname.caption=iif(buttonname.caption="Update On","Update Off","Update On")
17
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!