VBA Lesson 32: Excel Spin Buttons

This is an excerpt from Pierre Leclerc (www.excel-vba.com)

Spin Button

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 more attaractive by using a text box and a spin button.

The spin button is not really used by itself. Because the spin button does not 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 that is set within the properties of the spin button.

Properties

Among the other properties of the spin buttons  are:

- Min is the minimum value of the spin button. It can be negative
- Max is the maximum  value of the spin button. It can be negative
- Small is the value of the change when the user clicks on the arrows
- Large is the value of the change when the user clicks on the scroll bar of the spin button.

Go to the next lesson
Lesson 33 : Excel Image Controls