Here is a sample of what you will find in lesson 32 of the downloadable Tutorial on Excel macros
Lesson 32 on Excel macros (VBA):
Excel Spin Buttons
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
We hope you have enjoyed this introduction to lesson 32
Next Lesson: Excel Image Controls