How to check if variable was declared as a Variant type

Asked Jan 13 '18 at 15:08

Active Jan 13 '18 at 15:16

Viewed 866 times

Is there any way to check if variable was originally declared as Variant data type?

Consider the following example:

Public Sub mainMethod()
    Dim a As Variant
    Dim b As String

    a = "a"
    b = "b"

    Debug.Print "a: " & VBA.TypeName(a) & " | " & VBA.VarType(a)
    Debug.Print "b: " & VBA.TypeName(b) & " | " & VBA.VarType(b)

End Sub

Output is:

a: String | 8
b: String | 8

After assigning a text to the variable declared as Variant, both VBA built-in functions to check the type of variable (VarType and TypeName) treats it as variable of String type.

The effect is that variables a and b are treated the same way by those functions mentioned above, although originally they were declared with different data types.

I know how to check it by parsing method body with VBE functions, but it is not acceptable in this case.

edited Jan 13 '18 at 15:16

asked Jan 13 '18 at 15:08

mielk

3,890
12
19

The locals window will show you – QHarr Jan 13 '18 at 15:52
3

This might help https://stackoverflow.com/questions/33941363/determining-the-full-type-of-a-variable – QHarr Jan 13 '18 at 16:13
@QHarr Thank you, it is exactly what I needed. – mielk Jan 13 '18 at 17:29

How to check if variable was declared as a Variant type

0 Answers0