Spin Button to Add or Subtract One

This sample demonstrates how to use spin buttons, which allow you to add or subtract one from a number.

This template is based on the Invoice Template with Long Product Description (c4020).

1. First, backup the template.
2. Open the template.
3. Push down "Design Mode" button on the "Invoice" ribbon tab.
4. Switch to the Excel "Developer" ribbon tab. If this tab is not available in your Excel, do the following to make it visible:
   1. Right-click an empty area on the Excel ribbon and choose "Customize the ribbon"
   2. In the "Customize the ribbon" section, check the "Developer" option.
   3. Click OK to confirm the change.
   4. Now Excel shows the "Developer" ribbon.
5. In the "Controls" ribbon group, pull down "Insert".
6. In the "Form Controls" section, click "Spin Button" (the fourth in the list).
7. Now it returns to the worksheet. Click the location where you want to place the spin button to create it. In this case, we want to place it on the left side of the "Quantity" cell. You can move it by dragging and dropping.
8. Drag the border of the spin button to resize it. Each single spin button has two click spots (an up arrow and a down arrow), so it is recommended to make them as large as possible.
9. Right-click on the newly inserted button and choose "Format Control". Excel shows the "Format Control" dialog box with the "Control" tab activated by default.
10. Click the button in the "Cell Link" section and specify to which cell this button will be linked. For our first spin button, the target cell is $I$20 (i.e., the first "Quantity" cell).
11. With the spin button still selected, press "CTRL + C" on the keyboard and then "CTRL +V" to create a new button.
12. Move the second new button to the second "Quantity" cell. Right-click on it and choose "Format Control", Specify the linked cell for this second spin button.
13. Repeat the above steps to create spin buttons for the other four "Quantity" cells.
14. Once you have done the customization, click the "Design Mode" button again to exit design mode.
15. Save the template.