Make sure that the Forms toolbar is visible (ToolsCustomize and check
Forms).
Drag the button from this toolbar onto the worksheet
It will then prompt to assign a macro, select yours

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steven" wrote in message
oups.com...
Hi, there.

I have a macro runs on my excel file.
Only way I know to run this macro is pressing F5 in VB editor.

Now I want to create some type of userform has a button to activate my
macro.

Would you explain how to do this if you have a chance?

Thank you for taking time to read this..