Calculated GOTO

[Alan Nicoll]

Is a calculated goto or some kind of Indirect function possible in VBA?

Seeking guidance. ray:

Thank you.

 

[just_jon]

What conditions to what statement labels? Should be able to do it, directly or indirectly.

 

[Alan Nicoll]

I don't recall at this point why I wanted this capability, just remember I couldn't find a way to do it. Since being clued in to the existence of this board I'm remembering all the things about VBA that I tried to do over the last 4 months and couldn't get out of Help or the books I got from the library (can't afford to actually BUY a book).

 

[Yogi Anand]

Hi Alan:

I had a little play with what you asked. Unless i am missing something, I can consider Calculated Goto as Goto with a Condition, as in ...

Sub yCalculatedGoto()
    If [A1] = 3 Then GoTo Continue
    Exit Sub
Continue:
    If [B5] = 2 Then MsgBox "I am responding to a Condition"
    If [B5] < 2 Then MsgBox "I am still responding to a condition"
End Sub

Since I don't know the context in which you are asking this, I don't know whether this approach will work for you or not -- but I thought I will share this with you anyway!