Abbreviations

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

Dim dbDouble# 

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

PrevNext