Excel VBATutorial                      

             

Excel VBA Macros

Email to excel-vba.com

Excel Tutorial on Macros

 Excel Consulting

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

Spin Button

In the toolbox the spin  button  has this icon   VBA for Excel spin buttons 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.


We hope you have enjoyed this introduction to lesson 32
for more on this topic and a complete course on Excel macros download the
Tutorial on Excel Macros


Next Lesson: Excel Image Controls