DeanP
02-19-2019, 11:01 AM
Is the following possible in VBA:
I have 3 procedures, let's call then A, B & C that perform tasks in 3 different workbooks. Each procedure consists of several macros that run in sequence to produce the desired result.
At the start of each one of the procedures, users are required to provide information used in the code via a userform. As soon as the userform is unloaded the next part of each procedure is called. However, the same userform is used in all three procedures.
My question is, can all three of the next steps somehow be called from the one userform code?
So when procedure A is run, next step A is called, when B is run next step B is called from the same userform and so on.
I have 3 procedures, let's call then A, B & C that perform tasks in 3 different workbooks. Each procedure consists of several macros that run in sequence to produce the desired result.
At the start of each one of the procedures, users are required to provide information used in the code via a userform. As soon as the userform is unloaded the next part of each procedure is called. However, the same userform is used in all three procedures.
My question is, can all three of the next steps somehow be called from the one userform code?
So when procedure A is run, next step A is called, when B is run next step B is called from the same userform and so on.