Can I jump codes based on the response in a userform? I have several reports to format. What I want is, When I run a macro the user form with text box would pop up. And the end user would enter the number of reports to be formatted. If the user enters 6 I want the macro to jump to a code ( Any sub which I have created). Or if it says 5 it should to jump to another.
These codes have match index function, so I would be using a standard name to refer to these reports. Say Report1, Report2 etc.
Let me know if this is kind of a weird idea.
Bookmarks