Next, we’ll create the three buttons used to control the data preparation area.
The buttons will change the prep area and the chart will be built from that same prep area. This will give the user the illusion of the buttons changing the chart when really there is a go-between service behind the scenes.
The Option Buttons are accessible via the Developer tab.
If you do not see the Developer tab at the top of your program, right-click on any visible ribbon and select “Customize the Ribbon…”.
In the Excel Options dialog box, place a check in the box next to “Developer” on the righthand list and click OK.
With the Developer ribbon displayed, in the Controls group, select Option Button in the upper group of buttons labeled Form Controls.
After you click the Option Button control, click and drag a small rectangle somewhere on the screen to add your first option button.
Rename the button to “Game” by clicking within the text of the option button and rename the text.
We want two more Option Buttons, one for “Utility” and one for “Productivity”.
Right-click on the “Game” option button and select Copy. Click the Paste button twice to produce two duplicates of the “Game” button. Place the buttons in some temporary arrangement.
PRO TIP: You can hold the CTRL key and click the first option button to select it, then continue holding the CTRL key and drag the button to a new location and release the mouse. This will execute the mouse version of a Copy/Paste operation.
Rename the option buttons so each button represents a specific Division.