Change a cell's value using a button

[Guest]

Hi - I know its possible but have no idea how to do it - How do I set up a
cell with two buttons attached to it that increase and decrease the value in
the cell? I.e. if I have a cell with 10% in it and hit the "up" button, the
number goes up by 0.5% and down by the same amount if I hit the "down" button?
I am pretty good in Excel but dont know anything about macros - but Im
really not sure where you find this function. Thanks for your help in advance
anyone!

 

[Jason Morin]

No macros required. Use a spin button control rather than
2 buttons. Follow these steps:

1. Go to View > Toolbars > Control Toolbox.
2. Click once on the spin button icon and draw one on
your worksheet.
3. Right-click the spin button and go into "Properties".
4. Enter "A2" (no quotes) into "LinkedCell".
5. Close Properties.
6. Set up columns J and K to look like the following:

J K
0 0
1 0.5%
2 1.0%
3 1.5%
4 2.0%
5 2.5%
6 3.0%
7 3.5%

and so on.

7. Insert this formula into A1:
=VLOOKUP(A2,J:K,2,0)
and format as %.
8. Click the "Exit Design Mode" icon on the toolbar and
close the Control Toolbox.
9. Click away!

HTH
Jason
Atlanta, GA

 

[Guest]

nice - thanks very much...

No macros required. Use a spin button control rather than
2 buttons. Follow these steps:

1. Go to View > Toolbars > Control Toolbox.
2. Click once on the spin button icon and draw one on
your worksheet.
3. Right-click the spin button and go into "Properties".
4. Enter "A2" (no quotes) into "LinkedCell".
5. Close Properties.
6. Set up columns J and K to look like the following:

J K
0 0
1 0.5%
2 1.0%
3 1.5%
4 2.0%
5 2.5%
6 3.0%
7 3.5%

and so on.

7. Insert this formula into A1:
=VLOOKUP(A2,J:K,2,0)
and format as %.
8. Click the "Exit Design Mode" icon on the toolbar and
close the Control Toolbox.
9. Click away!

HTH
Jason
Atlanta, GA