TypeName()
This returns the variable type of any given varible name could be usefull for debugging purpose.
Use -[Variable Name] Would as it suggest be the name of the variableVB Code:
[color=#00007f]String[/color] = [color=#00007f]TypeName[/color]([Variable Name])
Example
So lets say you did,
VB Code:
Dim V1 As String Dim V2 As Long Dim V3 As Boolean 'etc MsgBox TypeName(V1) ' Would Return string MsgBox TypeName(V2) ' Would Return Long MsgBox TypeName(V3) ' Would Return Boolean





Reply With Quote