| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I launch my macro by button?
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to make a Button on a tool bar to launch an Add-in | Excel Discussion (Misc queries) | |||
| Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
| button to launch my userform | Excel Programming | |||
| Can I launch the Calendar Control from a Comand Button | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Hybrid Mode
