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 2821 users have said thank you to us this month