Here is a sample of what you will find
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 tip
To organize your discovery of Excel macros, the downloadable Tutorial on Excel Macros is divided in three sections (all 3 sections part of the single download):
Section 1: Excel Macros Programming (Chapters 1 to 10)
Section 2: Excel VBA Vocabulary (Chapters 11 to 23)
Section 3: Forms and Controls in VBA for Exce (Chapters 24 to 33)