Check the variable type : varType « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. varType

Check the variable type

 
Sub varTypeTest()
    Dim Age As Integer
    Dim birthdate As Date
    Dim firstName As String
    MsgBox varType(Age)
    MsgBox varType(birthdate)
    MsgBox varType(firstName)

End Sub








Related examples in the same category

1.The variable type of an array and an integer
2.Check the variable type: integer and integer array
3.Values returned by the VarType function