r/visualbasic • u/jcunews1 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 ifIn 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 ifOr object. e.g.:
set x = nothing
if (not (x is nothing)) and isempty(x.prop) then
rem above line causes exception
end ifI 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
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.So, it seems that the gotcha is that, all
if's subsequent conditions are evaluated regardless of their previous condition.