Running a Macro through a button vs. VBA

[adambush4242]

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

 

[jlclyde]

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

 

[adambush4242]

Thank you very much Jay that worked perfectly.

Adam Bush