Assigning a recorded macro to a Command Button!

[phillipsjr]

Hi Guys and girls, please help me.
I’m having trouble assigning a pre-recorded macro to a command button. After creating the command button, I right click on the button as suggested but I can’t se an “Assign Macro” option in the short menu. Is there any other way of assigning a pre-recorded macro to a command button or am I doing something wrong?

 

[Smitty]

Phillip,

Welcome to the Board!

If you're using a button created from the Forms toolbar, you can assign a macro by right-clicking.

If you're using a button created from the Control Toolbox, you need to call your macro from the button's click event. In Design mode, double-click the button and you'll get this:

Private Sub CommandButton1_Click()
  Application.Run "Your Macro"
  ' Or place your macro code here
End Sub

Hope that helps,

Smitty

 

[seepra]

I was searching for this one for a while..I was trying to run my command button by pasting the code, but it was not working.But Application.run worked for me!Thanks a lot Smitty !

 

[tabrez alam]

This really helped me... thanks a ton ... Smity