Easy Way to Reference Macros from Other Modules in Excel
This is a tip for referencing macros from other modules without having to remember exactly its name.
This works really well when you segment your modules by category or type or any other logical system where you can look at the module name and know which types of macros are inside of them.
As well, this tip allows you to avoid ambiguous naming issues with your macros if you reuse the same names for multiple macros (procedures).
Additional Resources
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel. This...
Tutorial: How to get data from separate workbooks in Excel. This tutorial includes an example using ...
Tutorial: There are two easy ways to combine values from multiple cells in Excel. In order to do thi...
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...
Macro: Free Excel UDF (user defined function) that displays the full file path and name of an Exc...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)