Discover sub-type of variant [RESOLVED]

[trisuglow]

I have a subroutine with a Variant parameter called v. Inside the subrouting I want to find the sub-type of v. That is, if someone passes in a Boolean I want to do something different from if they pass in an Integer.

If I look in the Watch window I can see that the sub-type is displayed. I just don't know how to access it from code.

Any ideas?

[Frans C]

Public Sub test()
Dim var As Variant
    var = True
    MsgBox TypeName(var)
End Sub

[trisuglow]

Fantastic - exactly what I wanted.