type variable vba code example

Example: vba type variable

debug.print TypeName(my_var)   ' String, Integer, Date...
debug.print VarType(my_var)	   ' vbLong, vbDate...