Insert Button in Excel

[rhhince]

I am trying to assign a command in in X5. I have the number set at 50%
in the cell. I would like to increase the value by 1% at every press
of the button or decrease the value by 1% at the press of another
button. How can that be done? I could quickly view results without
having to type in the actual number. Click,51%,click,52%,click,
53%.............click,52%,click,51%........

 

[Guest]

Hi,

You can insert a 'spin button' (from the Design mode) and link it to X5
which you want to increase or decrease.
You have to have

Regards,
B. R. Ramachandran

 

[Guest]

Curiousity kill the cat, but, How do you link a Spin Button to a Cell ?
THANKS

 

[Gord Dibben]

From the Forms Toolbar click on the Spin Button.

Create the button on the sheet.

Right-click >Format Control.

Note the dialog box for "cell link"

Or you could use the Spin Button from the Control Toolbox.

Right-click on created button and "Properties"

Set the cell under "Linked Cell"


Gord Dibben MS Excel MVP

 

[Guest]

Thanks again Gord Dibben, one more for the road.

 

[Gord Dibben]

Thanks for the feedback.

Keep on Learning<g>


Gord