What are the naming rules for VBA variable names?

The naming rules for VBA variable names are as follows:

1. Variable names must start with a letter.
2. Variable names can consist of letters, numbers, underscores (_), and periods (.).
3. Variable names cannot contain spaces or other special characters.
4. Variable names cannot be VBA keywords or reserved words, such as If, Then, For, etc.
5. Variable names are case-sensitive, meaning that the variable names “myVariable” and “MyVariable” are considered as different variable names.
6. It is best for variable names to reflect the purpose of the variable, making the code easy to understand and maintain.
7. Avoid using single letters or abbreviations as variable names, descriptive names should be used instead. For example, use “totalSales” instead of “ts” or “tsales”.
8. Avoid using variable names that are the same as existing objects, functions, or procedures to prevent confusion or conflicts.