How to group or organize dozens of macros?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

What's the best way to organize macros in Excel? Can vba
macro procedures be easily moved from one module to
another? Reason for the question is that I've
accummulated several dozen macros, and need to group them
for easy management.

Thanks for your help!
Randy
 
Randy said:
What's the best way to organize macros in Excel?
Click to expand...
I group macros with related functions into a module.
(e.g. all to do with charting in modCharting)
just so that I can more easily guess where to look.

Can vba
macro procedures be easily moved from one module to
another?
Click to expand...
Yes. Just cut and paste.

You have to be careful if there are any module-level variables that are
used, to ensure that the procedures that use them can still "see" them
after the move.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top