VBA for Beginners – Chapter 16 : Naming Conventions

Free eBooks for Beginners

VBA (Visual Basic for Applications) is a programming language used within Microsoft Office applications, such as Excel. One important aspect of writing VBA code is following naming conventions.

Naming conventions refer to the standard rules for naming variables, objects, and other elements in the code. These conventions help to make the code easier to read, understand, and maintain. Some common naming conventions in VBA include:

  • Using descriptive names: Names should describe the purpose of the element they refer to, such as “TotalSales” or “AverageTemperature”.
  • Using meaningful abbreviations: Abbreviations can be used as long as they are meaningful and commonly understood, such as “NumStudents” or “AvgAge”.
  • Avoiding spaces: Spaces should not be used in names, as they can cause errors and make the code harder to read. Instead, use underscores or camel case.
  • Avoiding reserved words: VBA has a set of reserved words that cannot be used as names, such as “Sub” or “End”.
  • Using a consistent naming convention: Choose a naming convention and stick to it throughout your code. This can be a combination of the above conventions or a different one, as long as it is consistent.


Following naming conventions in VBA can help to make your code easier to read, understand, and maintain. It can also help to prevent errors that may occur due to unclear or inconsistent naming.

In conclusion, naming conventions are an important aspect of writing VBA code. By following a set of standard rules for naming elements in the code, you can help to make your code more readable, understandable, and maintainable.


VBA for Beginners – Chapter 16 : Naming Conventions


Loader Loading...
EAD Logo Taking too long?

Reload Reload document
| Open Open in new tab

Download PDF [331.47 KB]

Applied Machine Learning & Data Science Projects and Coding Recipes for Beginners

A list of FREE programming examples together with eTutorials & eBooks @ SETScholars

95% Discount on “Projects & Recipes, tutorials, ebooks”

Projects and Coding Recipes, eTutorials and eBooks: The best All-in-One resources for Data Analyst, Data Scientist, Machine Learning Engineer and Software Developer

Topics included: Classification, Clustering, Regression, Forecasting, Algorithms, Data Structures, Data Analytics & Data Science, Deep Learning, Machine Learning, Programming Languages and Software Tools & Packages.
(Discount is valid for limited time only)

Disclaimer: The information and code presented within this recipe/tutorial is only for educational and coaching purposes for beginners and developers. Anyone can practice and apply the recipe/tutorial presented here, but the reader is taking full responsibility for his/her actions. The author (content curator) of this recipe (code / program) has made every effort to ensure the accuracy of the information was correct at time of publication. The author (content curator) does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause. The information presented here could also be found in public knowledge domains.

Learn by Coding: v-Tutorials on Applied Machine Learning and Data Science for Beginners