Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running a Macro through a button vs. VBA
I just created a simple macro to run in one of my workbooks. When I enter
visual basic and click Run Sub/User Form, the macro works fine. However, when I create a command button, type the name of the macro in the code for the button, and then push the button, I get a Compile Error:Argument Not Optional. I have several other command buttons in this workbook that work fine. Is there any way to fix this? It's kind of a pain to have to go into visual basic and click run instead of just clicking a button. Thanks Adam Bush |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running a Macro through a button vs. VBA
On Aug 30, 3:00 pm,
m wrote: I just created a simple macro to run in one of my workbooks. When I enter visual basic and click Run Sub/User Form, the macro works fine. However, when I create a command button, type the name of the macro in the code for the button, and then push the button, I get a Compile Error:Argument Not Optional. I have several other command buttons in this workbook that work fine. Is there any way to fix this? It's kind of a pain to have to go into visual basic and click run instead of just clicking a button. Thanks Adam Bush Adam, Delete your button. Make sure that you have the Forms tool bar open. Go to Toolbars, Right click, Pick Forms. Now insert the button. It shodul pop up and ask you what Macro you want to add to the button. You may have been using the Control Tool bar instead of the forms. The buttons work a little differently. Jay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running a Macro through a button vs. VBA
Thank you very much Jay that worked perfectly.
Adam Bush "jlclyde" wrote: On Aug 30, 3:00 pm, m wrote: I just created a simple macro to run in one of my workbooks. When I enter visual basic and click Run Sub/User Form, the macro works fine. However, when I create a command button, type the name of the macro in the code for the button, and then push the button, I get a Compile Error:Argument Not Optional. I have several other command buttons in this workbook that work fine. Is there any way to fix this? It's kind of a pain to have to go into visual basic and click run instead of just clicking a button. Thanks Adam Bush Adam, Delete your button. Make sure that you have the Forms tool bar open. Go to Toolbars, Right click, Pick Forms. Now insert the button. It shodul pop up and ask you what Macro you want to add to the button. You may have been using the Control Tool bar instead of the forms. The buttons work a little differently. Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pop-up when running a macro | Excel Discussion (Misc queries) | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
Running one macro from another | Excel Worksheet Functions | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Macro not running | Excel Discussion (Misc queries) |