Using Variables

When using variables in your VBA code, there are several things to remember to ensure that your code runs smoothly. Choosing the appropriate data type for each variable is critical, and it's also important to use global variables correctly.

Naming conventions for variables are very important. In Appendix G, "Naming Conventions," the Reddick naming conventions for variables are described. If you get into the habit of consistently naming your variables, your code will be easier to maintain over time, faster to debug, and will look more professional.

0 0

Post a comment