Link 'Button' to Macro

[donkirk]

I've created an ActiveX Button. How do I make clicking on this butto
execute a macro

 

[Paul Falla]

Make sure that you are in design mode and then double
click on your button. This will take you into the VBA
editor. You will see some code that looks like this:

Private Sub CommandButton1_Click()

End Sub

Where CommandButton(1) is the name of your button. Now
type in the name of your macro between the sub/end sub
sections. Save your changes and close the editor. Close
the design view and your button should work.

Hope this helps

Paul Falla