TypeName()

This returns the variable type of any given varible name could be usefull for debugging purpose.

Use -
VB Code:
  1. [color=#00007f]String[/color] = [color=#00007f]TypeName[/color]([Variable Name])
[Variable Name] Would as it suggest be the name of the variable

Example

So lets say you did,
VB Code:
  1. Dim V1 As String
  2. Dim V2 As Long
  3. Dim V3 As Boolean
  4. 'etc
  5.  
  6. MsgBox TypeName(V1) ' Would Return string
  7. MsgBox TypeName(V2) ' Would Return Long
  8. MsgBox TypeName(V3) ' Would Return Boolean