How do I launch my macro by button?

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..

Make sure that the Forms toolbar is visible (Tools>Customize 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" <hominco@gmail.com> wrote in message
news:1130192592.183491.154600@g49g2000cwa.googlegroups.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..
>