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?
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?