how to use vba spin boxes in excel  
Author Message
JHARRIS133





PostPosted: Tue Jan 11 23:53:46 CST 2005 Top

Excel Programming >> how to use vba spin boxes in excel

I am new to vba and need an example of the two types of number inputs eg spin
boxes. for large (100-100,000 increments of 100) and smaller numbers (1-25
increments of 1) can anyone help qwith examples?

Excel262  
 
 
Sharad





PostPosted: Tue Jan 11 23:53:46 CST 2005 Top

Excel Programming >> how to use vba spin boxes in excel So it seems you need to use the Spin Boxes in a worksheet.

Simply add the Spinbox where you want.
In SpinBox properties , put Min = 100, Max = 100000,
Small Change = 100.
LinkedCell = The cell where you want to show the values.
e.g. LinkedCell = A1

And when you need to know what value the user has chose you can do
userValue = Worksheets("SheetNAME").Range("A1").Value

OR
userValue = Worksheets("SheetNAME").SpinButton1.Value

Sharad




>I am new to vba and need an example of the two types of number inputs eg
>spin
> boxes. for large (100-100,000 increments of 100) and smaller numbers (1-25
> increments of 1) can anyone help qwith examples?