If-Else just stops

[doctormelodious]

Greetings,

I have the following field-validating VBscript in an Excel spreadsheet:

Please Login or Register  to view this content.

When cell K3 = 1, the script checks other cells in the inner IF statement, and puts up MsgBoxes if certain conditions are true. This much works fine.

The problem is: if all of the conditions in the inner IF statement are false (i.e. all the cells have what they're supposed to have in them, and no MsgBoxes have to be put up) the outer IF statement just STOPS. The next part of it:

Please Login or Register  to view this content.

is not executed. It's as though VBscript thinks the "End If" in the inner IF statment is part of the outer If statement (??).

Now, when cell K3 is not equal to 1, the entire outer IF statement is executed. So the problem is with the inner IF statment.

Any idea what the problem is?

Thanks!
DM

[antoka05]

Perhaps a solution is to use more 'If ... End If' statements and not 'If... Elseif... End If'.

This may be an idea (also if it's not elegant to read):

Please Login or Register  to view this content.

Regards,
Antonio

[doctormelodious]

Hi Antonio,

I thought about that very thing after I posted, and tried it. But the problem is, I want to stop after the first MsgBox. Give the user a chance to go back and fill in that one cell. By making separate IF statements. It fires off one MsgBox after another.

Or is there a way to EXIT a function? Like the "return" statement in Perl, for example.

Thanks much for your reply,
DM

[doctormelodious]

D'oh! I found it. "Exit Function"

Who would have guessed?

DM