Does VBA do static or dynamic type checking?
Posted on 2008-06-15
I'm trying to figure out if VBA does static or dynamic type checking. I can write the following and I know that it will generate an error at 'compile time':
Dim x As Integer
x = "hello."
But if we have the explicit option off, we can also declare variables un-typed on the fly, like:
x = 55;
Now is that being checked at compile time, or does the VBA interpreter try to figure out that x should be represented by an Integer only during run time?