how to use vba spin boxes in excel

[Guest]

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?

 

[Sharad Naik]

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