When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window. Once you have made the button, you can then code the VBA event that you want it to run ...

Now, right-click the spin button, choose Format Control, and click the Control tab to configure the control. The ‘Current value’ is the starting value for the control. The ‘Minimum value ...