Closing one sub from another

[Gkruithoff]

Hi all,

I'm trying to create a button on a Userform that will not only close the userform (that part I've got down) but also end the subroutine running behind the Userform.

There is a subroutine that calls the Userform that keeps running after the Userform is unloaded or hidden and I want the button on the User form to end the subroutine that calls the Userform

Essentially I'm just trying to figure out how to close or end one sub from another sub and I can't find the right commands

Any help?

 

[GlennUK]

To terminate all processes try the End command.

 

[Gkruithoff]

Hi Glenn,

thanks for the response - but no, unless you could show me how it is used, I've tried everything in regard to the End command but with no luck. Essentially I've tried:

Worksheets("Index").CommandButton1.End

and many variations thereof.

I'm trying to do this:

Sub EndingAnotherSub()

Worksheets("Index").CommandButton1.End
Unload Userform1

End Sub

but the CommandButton1 sub on the Index worksheet doesn't end or quit - not only does that line produce an error but the CommandButton sub continues to run in the back ground even after the Userform1 is stopped.

I want the procedures of CommandButton1 subroutine to end when called to end from another sub.

 

[GlennUK]

Like this:

Sub EndingAnotherSub()

End
' there's no point in putting any code after an End, is there ! ...Unload Userform1

End Sub

 

[Gkruithoff]

Sorry Glenn,

By placing and 'end' at that point of the sub, won't it just end the current sub - I'm wanting it to end another sub attached to a different worksheet

 

[GlennUK]

Sorry Glenn,

By placing and 'end' at that point of the sub, won't it just end the current sub - I'm wanting it to end another sub attached to a different worksheet

Have you actually tried it?

 

[Gkruithoff]

Hi Glenn,

sorry for the delayed response...I completely bow to your excel vba brilliance...I was completely over thinking that solution.

Thanks so much again

 

[GlennUK]

Hi Glenn,

sorry for the delayed response...I completely bow to your excel vba brilliance...I was completely over thinking that solution.

Thanks so much again

Glad to help.