kroz
11-04-2010, 12:12 AM
Hey guys,
I have a new question for you. One of my users has brought a situation to my attention. While running one of my macros he wants to pause execution so that he/she can fix some errors within the data.
What that means to me is that i have to put my macro on pause.
My idea so far is to put a YesNo button that will Exit Sub on vbYes, and then place a continue button inside the worksheet with "continue" on it.
The only problem is that if i want to go with this i lose all the info in my variables - this approach will involve splitting my macro into two separate pieces of code.
Is there any other way of doing this? I'm thinking somewhere along the lines of a Pause/Resume button or maybe using a goto Label so that i would not reset my variables.
Thank you.
I have a new question for you. One of my users has brought a situation to my attention. While running one of my macros he wants to pause execution so that he/she can fix some errors within the data.
What that means to me is that i have to put my macro on pause.
My idea so far is to put a YesNo button that will Exit Sub on vbYes, and then place a continue button inside the worksheet with "continue" on it.
The only problem is that if i want to go with this i lose all the info in my variables - this approach will involve splitting my macro into two separate pieces of code.
Is there any other way of doing this? I'm thinking somewhere along the lines of a Pause/Resume button or maybe using a goto Label so that i would not reset my variables.
Thank you.