Also known as Type Declaration Suffixes.
This is not used so much know but does work and it saves space.
It is also possible to tell VBA the type of a variable by appending a special character to the end of the variable name.
Dim iNumber% 'integer
Dim lAverage& 'long
Dim sngTotal! 'single
Dim dbTotal# 'double
Dim cProfit@ 'currency
Dim sFirstName$ 'string
Data type Abbreviation Declaration Characters
VBA does allow you to append a character to a variable's name as a quick way of indicating its data type.
This method of declaring variables should not be used and is only available for backwards compatibility purposes.
The following line will declare a variable with a Double data type
This line however should be declared using the "As" keyword.
Dim dbDouble As Double
Data type Abbreviations / Suffixes
If you use the abbreviations then you do not have to declare the type. If you use count% then you do not have to type "as integer".
These are still supported in Visual Basic 2005
These abbreviations can be useful for assigning literals to variants
MyVariant = 10#
© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited