Userform cancel button to stop background proces

[kmakjop]

Hello,

I created a userform that will pop-up in the middle of a pocess once a duplicated record is found on the sheet. This userform will prompt the user to either cancel or continue with the duplicated record. To continue is easy, i simply unload the form; however stopping the process is proving to be a bit more difficult. If i unload the form the process continues, how can i code the cancel button i created on the form that once pressed it stops all the macros that was running on the sheet?

The usform is simple, it has two buttons, one to continue, one to cancel (that should stop the already running process).

Kindly assist if possible thank you.

[kmakjop]

Help anyone, this issue is really preventing me from continuing with my code.

Help please

[Leith Ross]

Hello kmakjop,

Post your workbook so we can see what your code and what your are doing.

[kmakjop]

Hello kmakjop,

Post your workbook so we can see what your code and what your are doing.

Thanks for responding. However its not that complicated. The application is creating a text file and if detects a duplicate record in the sheet it will show the userform. the userform will prompt the user to either continue or cancel. If he clicks cancel i unload the form and the process continues. If he clicks cancel, then the entire application should halt and stop there-do nothing else until process is initaited again. I was thinking that there was a code that i could place under the cancel button's click event that will just end all process, but either no such code or i just cant find it over the internet.

[Leith Ross]

Hello kmakjop,

Don't unload the user form, but Hide it. This will keep your variables and their values intact. You can have your Cancel button set a boolean variable that your other code can check. If the variable is true then stop the process by exit then code and unloading the user form.

[kmakjop]

Hello kmakjop,

Don't unload the user form, but Hide it. This will keep your variables and their values intact. You can have your Cancel button set a boolean variable that your other code can check. If the variable is true then stop the process by exit then code and unloading the user form.

Okay thanks. Give me a few minutes to try and execute what you said, i will post my results shortly...Thank you again.

[kmakjop]

Okay thanks. Give me a few minutes to try and execute what you said, i will post my results shortly...Thank you again.

Ok i did something similar to what you suggested, Just that i had some problems accessing the variables from the userform not sure why. however i just substituted the variable with a specific cell and its fine. I would prefer using an actual variable but it was eating away too much of my time to get it done. But hey variable or cell they both do the samething so its fine for now. Thanks.

[Leith Ross]

Hello kmakjop,

Good to hear you it working.Should I mark this posted solved?

[Leith Ross]

Hello kmakjop,

Good to hear you have it working. Should I mark this posted solved?

[kmakjop]

Hello kmakjop,

Good to hear you have it working. Should I mark this posted solved?

I am currently searching to see where to add the close tatus to the post, but not seeing that. Yeah go riht ahead, thanks.