VBA: Disconnect from called sub

[peimar]

Let's say that I have to two subs:

Sub subA()[INDENT]If (some condition)<some condition=""> is True Then</some>[/INDENT]
[INDENT=2]Call subB[/INDENT]
[INDENT]Else[/INDENT]
[INDENT=2]' Some code[/INDENT]
[INDENT]End If[/INDENT]
End Sub

Sub subB()[INDENT]'Some code[/INDENT]
End Sub

Is it somehow possible to disconnect subB from subA once called? So that once subA calls subB, subA is ended while only subB continues running while subA has discontinued.

 

[Logit]

.
As your macro is written, once you go to Sub B, Sub A is ignored. Nothing else occurs relative to Sub A until everything
has been concluded in Sub B.

Sub subA()
If (some condition) is True Then
     Call subB
     'at this point, only those commands in Sub B are running. Nothing in Sub A
     'is done until Sub B concluded and the attention returns to Sub A.
     'When things return to Sub A, it will come back to this point (after the line
     ' Call subB) and proceed to process code lines the might follow.
Else
     ' Some code
End If
End Sub

Does this help or did you view this differently or mean something different ?

 

[peimar]

I meant something different. As you say, once subB is processed, it returns back to subA and finishes there. Instead, once I get to subB, I do no longer want subB to be connected to subA. This way, when subB ends, nothing more happens.

I am not looking for a solution where you put 'End' in the end of subB or anything like that. I am only asking for a way where you for instance call subB within subA and simultaneously ends subA while subB continues, or anything similar. Hard to explain the reason or bigger context of why I need this, so sorry about that.

 

[Fluff]

As far as I know, what you're asking for is not possible.

 

[Logit]

.
I agree with Fluff ... I do not believe that is possible.

The only thing you might do is along the lines of "end" .. except after the line Call subB, type Exit Sub.

It still means SubB has to finish its work and then return to SubA, but you will know that nothing more in SubA will get processed.

 

[Logit]

.
One other thought ... just for the sake of discussion but most likely not a viable approach.

At the top of your SubB, you could include lines of code that would delete SubA from the workbook. Of course the downside
is SubA would no longer be available for future use without re-creating it.

 

[Kyle123]

I can’t think why you want to do this. But how about using ontime to run subb, I think that meets you requirement

 

[Rick Rothstein]

As far as I know, what you're asking for is not possible.

I would think you could set up a global variable and set it in one sub and test for that setting in the other sub reacting (using End Sub) as needed.