Executing Sub procedures directly
Having created a Sub procedure is a waste of time if it doesn't make your life easier. Instead of creating a table manually, you want the Sub procedure to do the work automatically.
So, how do you get the Sub procedure to work? You run it, or execute it. Whether you call it by running the code or executing the code makes no difference. All you want to do is to get the code to do what it was supposed to do.
In this recipe, we will be investigating one specific way of executing a Sub procedure. It is not better or faster, it's just one of about ten different ways in which we can run a Sub procedure.
Getting ready
Make sure that you are still in the code window that contains the procedure we created in the previous section.
How to do it…
To execute a Sub procedure directly, do the following:
- Click anywhere in the code window of the procedure you want to run.
- Press Run | Run Sub/Userform. (The keyboard shortcut...