View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Commandbutton in UserForm to run Macro

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.

--
Regards,
Tom Ogilvy


"salihyil " wrote in message
...
i have created 2 commandbutton in UserForm. i also created 2 macros but
i dont know how to link the commandbuttons in userform to macro.

seeking for help!!!

thanx


---
Message posted from http://www.ExcelForum.com/