VBA Naming Conventions
Variables hold data. Name them after what they're used for, not after their data type or scope, using a noun. If
you feel compelled to number your variables (e.g. thing1, thing2, thing3), then consider using an appropriate
data structure instead (e.g. an array, a Collection, or a Dictionary).
Names of variables that represent an iteratable set of values - e.g. an array, a Collection, a Dictionary, or a Range
of cells, should be plural.
Some common VBA naming conventions go thus:
For procedure-level Variables:
For module-level Variables:
SHOUTY_SNAKE_CASE is commonly used to differentiate constants from variables: