Macro stopping and starting.
 

Hi,

I've got two different userforms, both with input fields.

When I've finished working on one I press a commandbutton that runs a macro
containing validations and the processing of the data into the sheets. After
the validation and before inserting data into the sheets, I would like to
call another userform and let the macro wait until I'm finished with the
inputs on the other userform, before continuing with the remaining code.

Is this possible?

Cheers,

Paul

Macro stopping and starting.
 

You can not really pause macro execution while you do other things. What you
can do is to split the macro in two. Execute the first macro ending by
opening the user form. When you close that form you can kick off the second
macro.
--
HTH...

Jim Thomlinson


"Paul" wrote:

Hi,

I've got two different userforms, both with input fields.

When I've finished working on one I press a commandbutton that runs a macro
containing validations and the processing of the data into the sheets. After
the validation and before inserting data into the sheets, I would like to
call another userform and let the macro wait until I'm finished with the
inputs on the other userform, before continuing with the remaining code.

Is this possible?

Cheers,

Paul

Macro stopping and starting.
 

Jim,

Thanks for your reply, I already thought of that as a back-up.

Thanks

Paul
"Jim Thomlinson" wrote:

You can not really pause macro execution while you do other things. What you
can do is to split the macro in two. Execute the first macro ending by
opening the user form. When you close that form you can kick off the second
macro.
--
HTH...

Jim Thomlinson


"Paul" wrote:

Hi,

I've got two different userforms, both with input fields.

When I've finished working on one I press a commandbutton that runs a macro
containing validations and the processing of the data into the sheets. After
the validation and before inserting data into the sheets, I would like to
call another userform and let the macro wait until I'm finished with the
inputs on the other userform, before continuing with the remaining code.

Is this possible?

Cheers,

Paul