How to make button in user form call a module

**TomT** · 04-22-2008, 02:51 AM

I have three modules, each of which sorts the Excel chart using different columns. I have created a user form that has four buttons. The first three are supposed to call each of the three modules. The last one closes the user form.

I cannot figure out the very simple task of how to call each of the modules (the Close button works fine). I have been using the book "Excel Programming" by Jinger Simon, but the author does not explain this very necessary and common procedure.

So two questions: One, how can I call a macro by clicking a button in a user form? Two, are there any good books that explain VBA for Excel?

Thanks,
Tom

**mudraker** · 04-22-2008, 03:23 AM

As you can close your form I assume you know haw to attach code to a macro button

To have your button macro call another macro use
the command of

Please Login or Register  to view this content.

or you can leave the call part of the command out and just use the macro name

Please Login or Register  to view this content.

I prefer to use the Call statement as it makes it easier for me when debugging.

**TomT** · 04-23-2008, 02:24 AM

Your code worked, thanks!
Tom

**akaron** · 08-13-2012, 10:27 AM

Originally Posted by mudraker

To have your button macro call another macro use
the command of

Please Login or Register  to view this content.

mudraker,

I am trying to do the same thing, but when I try to run it, the program is giving me a compile error: "expected variable or procedure, not module" What am I doing wrong?

**JosephP** · 08-13-2012, 10:36 AM

you gave the module and macro the same name. rename one or the other.

**akaron** · 08-13-2012, 10:59 AM

Thank you! Dumb mistake!

**arlu1201** · 08-13-2012, 11:01 AM

Akaron, for future reference,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.