What are possible suffixes after variable name in VBA?
- by archimed7592
As I've already figured out, there is at least six of them: !@#$%&.
Here is snip:
Dim A!, B@, C#, D$, E%, F&
Debug.Print "A! - " & TypeName(A)
Debug.Print "B@ - " & TypeName(B)
Debug.Print "C# - " & TypeName(C)
Debug.Print "D$ - " & TypeName(D)
Debug.Print "E% - " & TypeName(E)
Debug.Print "F& - " & TypeName(F)
Outputs
A! - Single
B@ - Currency
C# - Double
D$ - String
E% - Integer
F& - Long
Where is documentation on this syntax sugar?
What other possible suffixes are there?
Is there one for Date?