Stopping a function

[mpnorris]

Here is my situation. I have a series of IF statements. I want to be able to put in code to stop the program from continuing if one of these conditions are met. IF none of the conditions are met the ELSE statement should run.

I have the code working except for the Else statement also runs. I was hoping to put in code at the end of each IF statments to stop the code from continuing.

I think this should be easy but I do not know the syntax. Any help would be greatly appreciated.

 

[jdgreen]

Change your Else statement to another ElseIf statement and make your Else statement exit the function.

John Green

 

[scriverb]

This is the format that you should follow. You can have unliminted ElseIf's with their corresponding statements prior to the final Else.

If <expression> Then
'[statements]
ElseIf <expression> Then
'[statements]
ElseIf <expression> Then
'[statements]
ElseIf <expression> Then
'[statements]
ElseIf <expression> Then
'[statements] ...
Else
'[statements]
End If

If you follow this format you will get all of your conditions to work including the final else which corresponds to the the false answers of all the above listing IF's.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[mpnorris]

hankyou. Your responses were very helpful. Thanks again.