Commandbutton in UserForm to run Macro

  • Thread starter Thread starter salihyil
  • Start date Start date
S

salihyil

i have created 2 commandbutton in UserForm. i also created 2 macros bu
i dont know how to link the commandbuttons in userform to macro.

seeking for help!!!

thanx:rolleyes: :rolleyes
 
in the VBE with the userform visible, double click on the first command
button.

You should see

Private Sub CommandButton1_Click()

End Sub

(it will have the name you assigned you commandbutton)

Put a call to your macro there
Private Sub CommandButton1_Click()
mymacro1
End Sub

In the left dropdown at the top of the module, select the other
commandbutton. In the left dropdown, select click. You should get a
similar declaration and you can call your second macro from there.
 
Back
Top