Change a cell's value using a button

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!
--
Ashley

check out the spinner from the view > toolbars > forms menu
Though this would require you to maintain 2 cells for your example.

- Mangesh

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


>-----Original Message-----
>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!
>--
>Ashley
>.
>

nice - thanks very much...

"Jason Morin" wrote:

> 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
>
>
> >-----Original Message-----
> >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!
> >--
> >Ashley
> >.
> >
>