UniformSoftware main content

Spin Button to Add or Subtract One

Template#: c4083

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
480 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Spin Button to Add or Subtract One

Detail

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.

Format and Specification

Template#c4083
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns4
Lines6
Line Height (Points)39.75
Print Area$D$3:$L$41
Papaer OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00
PriceFree