How can I tie a VBA macro to a button in Excel

Question

I have created a macro and a button but I can't see where to edit the button setting to invoke the macro. I'm using Excel 2003.

What kind of button is it? ActiveX or Form Control? If you are not sure then, how did you add the button? From the forms toolbar or the control toolbar? — Siddharth Rout
– Siddharth Rout, Commented May 16, 2012 at 18:09

Scott Holtzman · Accepted Answer · 2012-05-16 18:37:44Z

4

If you've used a Form Control. The chance to assign a macro will come up right after you add the button to the sheet. Or, if the button is already on the sheet, you can right-click on it and select Assign Macro.

If you've used an ActiveXControl, right-click on the button and select View Code. This will open up the VBE with

Private Sub myCommandButtonName_Click() 

End Sub

From this sub call your macro like so...

Private Sub myCommandButtonName_Click() 

Call myMacro

End Sub

answered May 16, 2012 at 18:37

Scott Holtzman

27.3k5 gold badges42 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I tie a VBA macro to a button in Excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related