command button

[cmyers5613]

I am new to using vba and have created 7 macros and am unsure as to if it is possible to assign these to a single command button and if so what my code should look like; or can I assign the module i have them in to a button and if so how would i code that. any help is greatly appreciated.

[gmr4evr1]

cmeyers,
Welcome to the forum.

With the limited information you provided it will be difficult to answer the questions.
As far as I know, you can only assign one macro per command button, however, if the button needs to run all the macros, you may be able to combine them all into one.
Where is the button going to be, on the sheet or in a userform?
If in a sheet, right click the button then click assign macro, a list of available macros will appear.
If on a userform, double click the button on the userform and a VBA editor window will open and the code can be pasted/written there.
We would have to see your code to be able to rewrite them into one module.

[Sintek]

Like this...Change Macro1 etc to your macro names

Please Login or Register  to view this content.

[gmr4evr1]

Duh.....Thanks sintek, I overlooked the simple once again.