Today’s VBA Productivity Tip provides an overview of a little-known—yet simple—technique for managing ambiguous names (duplication) issues in VBA subroutines and functions. By using the dot operator, subroutine and function calls can be targeted to specific modules. Overview Generally, it’s advisable to make sure all subroutines and functions (procedures) within …
Today’s VBA Productivity Tip introduces the editor window’s procedure list. This list serves two purposes: help find existing subroutines, or access built-in subroutines.
This VBA Productivity Tip introduces a very simple feature that can be used to organize modules in complex projects — naming individual modules. By providing modules with specific and informative names, developers can easily group and compartmentalize VBA subroutines.
This post introduces our first VBA Productivity Tip, a summary of the VBA Editor’s intellisense feature. Intellisense can help reduce the occurrence of common syntactical and semantic errors by providing useful tooltips and lists to help you code more efficiently.