Declaring
Should they be declared at the very top or inline ??
Variable Names
The first character must always be alphabetic.
You cannot use spaces or periods.
Variable names can use alphabetical characters, number and some punctuation characters but not ( * . , # $ % & !).
The use of the underscore character is also encouraged.
The name must start with a letter and can have a maximum of 254 characters.
A variable must begin with a letter or an underscore
Variable names can be constructed from letters and numbers and the underscore character.
Variable names cannot be the same as C# keywords.
Case Sensitive
Multiple Variables
string firstName, lastName;
This statement is valid although the variable sFirstName is defined as a Variant variable and not as a string variable.
Dim sFirstName, sLastName As String
VBA does not let you declare a group of variables to all be of the same data type.
You must specify the type of each variable explicitly.
You should always try and declare each variable on a separate line
Dim sFirstName As String
Dim sLastName As String
You could put this on one line
Dim sFirstName As String, sLastName As String
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext