VBA Lesson 32: Excel Spin Buttons
This is an excerpt from Pierre Leclerc (www.excel-vba.com)
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.
Among the other properties of the spin buttons are:
- Min is the minimum value of the spin button. It can be negative
Go to the next lesson