Checking Variable type

[Aaron Young]

Try the VB Function, TypeName(), i.e.

Dim iInteger As Integer
Dim sType As String

sType = TypeName(iInteger)
MsgBox sType

sType would contain "Integer"

------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]

[Sparhawk]

Is there a function or API call I can use in VB to determine the "type" of variable I am using (given the variable name). Saying the word type I mean "Integer", "Long", "Double"