Variable Type [RESOLVED]

[TheVader]

Sorry for the dumb question, but I couldn't find it in any previous topics. How do I find out which variable type has been defined? I'm using a Variant and apply a value of 2 to it. However, when I define the variable as a single, double, integer, long or anything else it doesn't work. I need to know which variable type is used through the Variant. Thx.

[zuperman]

Originally posted by TheVader
How do I find out which variable type has been defined?

TypeName Function Example
This example uses the TypeName function to return information about a variable.

' Declare variables.
Dim NullVar, MyType, StrVar As String, IntVar As Integer, CurVar As Currency
Dim ArrayVar (1 To 5) As Integer
NullVar = Null   ' Assign Null value.
MyType = TypeName(StrVar)   ' Returns "String".
MyType = TypeName(IntVar)   ' Returns "Integer".
MyType = TypeName(CurVar)   ' Returns "Currency".
MyType = TypeName(NullVar)   ' Returns "Null".
MyType = TypeName(ArrayVar)   ' Returns "Integer()".

Regards...

[TheVader]

Never heard of the TypeName method. Thanks a lot.

[zuperman]

TypeName Function

Regards...