D
DonFlak
I want to be able to write a macro that when run looks at a user entry
(numeric) and based on that answer, runs a specific corresponding
macro.
Example:
User open the workbook and answers the prompted question with a 1 and
clicks the "submit" button. The macro looks at the answer (the 1) and
opens another workbook and runs macro 1. If however the user entered 9
then the macro would open the workbook and run macro 9.
Is there a way to do this?
I know how to open another workbook and run a macro from a macro. The
part I don't know is how to have the macro decide which macro in the
other workbook to run.
Any assistance is greatly appreciated.
Don
(numeric) and based on that answer, runs a specific corresponding
macro.
Example:
User open the workbook and answers the prompted question with a 1 and
clicks the "submit" button. The macro looks at the answer (the 1) and
opens another workbook and runs macro 1. If however the user entered 9
then the macro would open the workbook and run macro 9.
Is there a way to do this?
I know how to open another workbook and run a macro from a macro. The
part I don't know is how to have the macro decide which macro in the
other workbook to run.
Any assistance is greatly appreciated.
Don