Stop a procedure call if..

[mantis_sg]

Hi is there a way to end all procedures or to skip/stop a procedure from running if an if statement is satisfied within another procedure... wow, not sure if I understand this...

was thinking of setting a global boolean and setting it to true in the if loop

but how would I code this and declare the variable, and how would I call it from within my main procedure? thanks.

 

[BrianB]

A simple version. This stops the macro.

If x = 1 Then
    End
End If

 

[mantis_sg]

yeah, it's a little more complicated than that...

a button on a form does something like this....

Call a

If boolean = 1 then skip sub b
End if

Call b

End Sub

-----------------------------------------------------

Sub a

if something = true then
boolean = 1
Exis sub

End if

End Sub

--------------------------------------

Sub b

blah blah blah

End Sub

 

[mantis_sg]

anybody?

 

[BrianB]

Need to change your logic. There is no code for "skip" - only various ways to select something to *do*. 'If' is one ..

The basic form is :-

If MyBoolean <> 1 Then
    b
Else       ' can be omitted
    ' do something else
End If