Add 2 spinners for a single cell?

[venshi]

Hi, would like to ask if anyone knows how to add 2 spinners for a single cell? For example, the first spinner would be increasing the value by 1 while the other spinner would increase the value in the cell by 0.1. Thus if I want to increase the cell by 20.5%, I would just have to click the first spinner twice and the second spinner 5 times. May any geniuses here please enlighten me? Thanks!!!!

 

[venshi]

Try this:
Needs no formula:

Up button increases by 1
Up button increases by 0.1

Down button decrease by 1
Down button decreases by 0.1

you mind explaining this?? sorry quite new to excel here!!

 

[venshi]

Try this:
Needs no formula:

Up button increases by 1
Up button increases by 0.1

Down button decrease by 1
Down button decreases by 0.1

Do you mind explaining in detail about this? Sorry really new to excel!!

 

[Greg Truby]

shg (and Gerald) have you on the right track with two spinners and using a sum formula. Their suggestion would allow you to just use Excel forms spinbutton controls which allows you to keep the workbook macro free (unless you have other requirements that necessitate using VBA/macros).

Yup just tried that and it works. Woohoo! However, one flaw of it that is the second spinner cannot influence the first spinner. For example, if my first spinner (A1) is set by incremental of 1% and my second spinner (A2) is set at 0.1%. When I click the first spinner twice upwards the cell (A3) will turn into 2%. However, I am unable to use to reduce the value of 2% by 0.1 to 1.9% using the second spinner because my set cell link for the second spinner is still actually zero. Any tips on solving this issue?

As far as the problem decrementing goes if you've not clicked the second spinbutton: just set the second spin button to something like a minimum of 0 and a maximum of 1000 and an increment of 1 and seed it with a value of 500 and adjust your formula accordingly, i.e.

=A1+(A2-500)/10

 

[My Aswer Is This]

Create two Active x spin buttons on your sheet named SpinButton1 and SpinButton2.
These are the default names
And then put these script in your worksheet:

Private Sub SpinButton1_SpinDown()
'Goes down by 0.1
Cells(1, 1).Value = Cells(1, 1).Value - 0.1
End Sub
Private Sub SpinButton2_SpinDown()
'Goes down by 1
Cells(1, 1).Value = Cells(1, 1).Value - 1
End Sub
Private Sub SpinButton1_SpinUp()
'Goes Up by 0.1
Cells(1, 1).Value = Cells(1, 1).Value + 0.1
End Sub
Private Sub SpinButton2_SpinUp()
'Goes up by one
Cells(1, 1).Value = Cells(1, 1).Value + 1
End Sub

These buttons make changes to Range("A1"). Modify Range to your needs.

Try this:
Needs no formula:

Up button increases by 1
Up button increases by 0.1

Down button decrease by 1
Down button decreases by 0.1

Do you mind explaining in detail about this? Sorry really new to excel!!