Commandbutton in UserForm to run Macro

[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

 

[Tom Ogilvy]

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.

 

[salihyil]

thanks Tom Ogilvy

i appriciate