Thursday, July 25, 2013

Suffixes after variable name in VBA

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)
A! - Single
B@ - Currency
C# - Double
D$ - String
E% - Integer
F& - Long
For Reference:
http://support.microsoft.com/kb/110264

No comments:

Post a Comment