Confusion about how call works within an if/elseif statement

[Moonbeam111]

Good afternoon all

I have this simple watered down code here: (Just for demonstration purposes)

If Range("G41") = 'rest of code here' Then
Call macro1
Call macro2
ElseIf Range("G41") = 'rest of code here' then
msgbox 'message here'
ElseIf Range("G41") = 'rest of code here' then
msgbox 'message here'
ElseIf Range("G41") = 'rest of code here' then
Call macro1_alternate
Call macro2_alternate
End If

Im confused about it. Basically when I run it, it doesnt test each elseif statement in sequence. Apparently after macro2 is called the code immediately jumps to end if. Is this normal VBA behavior or is something in my code wrong? If not, what workaround is there so that I get each elseif statement tested? I prefer not to use select case if possible.

 

[Cubist]

If macro2 was executed, that means the first IF test was passed. When a test is passed, the IF ends. It'll only go to the next ELSEIF if the prior tests failed.

 

[Moonbeam111]

That explains it, thank you. Ill have to restructure my code. Maybe put an end if after macro2.