Executing Sub procedures using buttons
In this recipe, we're going to take the running of macros one step further by executing them when clicking on a button.
There is a very good reason for creating buttons on a spreadsheet. Some users may not be familiar with the VBA Editor, meaning that they wouldn't know how to run a macro from there. Even the Macro dialog box can be a challenge. That's when buttons become very useful, because even a novice will know that clicking on a button normally makes something happen.
Getting ready
Ensure that Excel is open on the same workbook that we've been working with so far.
How to do it…
The following steps will help you complete this recipe:
- In any worksheet, click on Developer | Controls | Insert | Button (Form Control):
Figure 4.4 – Inserting the Button form control
- Now click and drag anywhere on the worksheet to create a button. Size is not important, but remember that a very small button...
