DataTypes
Using the Data Types Symbols
You may have seen some methods written as Left$(...) and not Left(...)
$ version returns a String, and the non $ version returns a variant
Here is a list:
End with:
$ | String |
% | Integer (Int32) |
& | Long (Int64) |
! | Single |
# | Double |
@ | Decimal |
Start with:
&H | Hex |
&O | Octal |
VBA
Private Sub Form_Load()
variable1=Dir$(some_path)
variable1=Dir(some_path)
variable1=string(Dir(some_path))
End Sub
By: Alex Hedley
Click here to sign up for more FREE tips
|