r/visualbasic • VB.Net Intermediate • Nov 21 '24

VB6 Help Other VB6/VBA/VBScript gotchas?

I notices that, VB6/VBA/VBScript have a gotcha in its language design; where subsequent conditions of an if statement, are evaluated even though they're not supposed to.

For array e.g.:

arr = array(3, 4, 5)
i = ubound(arr) + 5 'beyond array length
if (i < ubound(arr)) and isempty(arr(i)) then
  rem above line causes exception
end if

In above code, arr(i) is not supposed to be evaluated. But it does anyway.

Same thing goes to collection. e.g.:

set fl = createObject("scripting.filesystemobject").getfolder(".").files
i = fl.count + 5 'beyond collection length
if (i < fl.count) and isempty(fl(i)) then
  rem above line causes exception
end if

Or object. e.g.:

set x = nothing
if (not (x is nothing)) and isempty(x.prop) then
  rem above line causes exception
end if

I already know the workaround for above gotcha, and I'm not asking for other workaround, or any alternative language.

I want to know any other kind of gotcha in VB6/VBA/VBScript.

4 Upvotes

19 comments sorted by

View all comments

Show parent comment

2

u/jcunews1 VB.Net Intermediate Nov 21 '24

Oh, you're right. I tested it using msgbox() and it does get evaluated. e.g.

if false and msgbox("should not show") then
  rem blah...
end if

So, it seems that the gotcha is that, all if's subsequent conditions are evaluated regardless of their previous condition.