assigning macro to button

B

BorisS

In versions before 03, I remember there was a way to simply assign a macro to
a button that was created. Now I cannot tell how to do it. I have used the
control toolbar to create the toolbar and I have a macro, but I don't know
how to assign it.
 
R

Rowan

When you create the button from the Controls Toolbox it will be in
design mode. Double clicking it should take you to the default event for
the button i.e. the sheet module for the relevant worksheet with code eg:

Private Sub CommandButton1_Click()

End Sub

Change this to

Private Sub CommandButton1_Click()
Call MyMacro 'your macro name
End Sub

Alternately, use a button from the Forms Toolbar. Right click the button
and select Assign Macro.

Hope this helps.
Rowan
 
Top