Macro dont stop completely

[cvecve]

Hello,
I have a userform that starts a macro but after exit and end the macro it is still "running" and in the editor i have to press the 'reset' button in the command bar to stop it completely.

How can is stop it automatically? With vba code?

Thanks in advance for your help.
Cees

 

[RobP]

Hi,

you'd probably have to share the macro code driving your userform to allow people here to see whats happening ..

Sounds like it is stuck in an infinite loop for some reason...

Rgds
Rob

 

[Joe4]

Welcome to the Board!

As Rob said, we would probably need to see your code. See here for how to post your code using Code Tags to make it easily readable on this board:

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

 

[cvecve]

Hi,
i found the solution, just put the 'end' command before the end sub.

 

[Joe4]

Hi,
i found the solution, just put the 'end' command before the end sub.

That usually is not necessary, but without seeing your code, we really cannot comment on it.