In Excel vba how do you Launch code a standalone Module from a Form or other Module ?

  • Thread starter Thread starter tmb
  • Start date Start date
T

tmb

I can create stand alone modules in Excel vba by clicking File New Module or
some such.

How can I run the code in those stand alone modules from another module or a
Form that has its own code?

Thanks for any help.

tmb
 
If you're talking about "New Project" from the VBA File menu,
this create a new VBA project that is used to create COM Add-Ins,
a discussion of which is beyond the scope of a newsgroup reply.
In general, you want to use the Insert menu to create a new
module in an existing workbook.

In VBA, there is no such thing as a "stand-alone" module; all
modules are contained within a workbook.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top