Program by Levels

This page is one of the 33 lessons from the
Tutorial on VBA for Excel (Macros)
VBA for Excel made simple

Lesson 3-10: Spin Buttons
(Levels: Intermediate, Advanved)

In the toolbox the spin  button  has this icon   .

You can ask a user to enter a value directly in a text box but you can make things a little fancier by using a text box and a spin button.

The spin button is not really used by itself. Because the spin button doesn't show its value it is usually used with a text box. The text box shows a number and by clicking on the arrows of the spin button the value in the text box is increased (or decreased) by 1, or 5 or 10...by whatever value set within the properties of the spin button.

Properties

The other interesting properties of the spin buttons  are:

- Min is the minimum value of the spin button. It can be negative
- Max is the minimum value of the spin button. It can be negative
- Small  Change is the value of the change when the user clicks on the arrows
- TabIndex is a property that you change through the "Tab Order" functionality as shown in the UserForms lesson.

Code

On the "Change" event of the spin button you will have code modifying the value of the text box that accompanies it:
tbxInput=spbInput

This page is one of the 33 lessons from the
Tutorial on VBA for Excel (Macros)
VBA for Excel made simple