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%........

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






rhhince" wrote:

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%........

Curiousity kill the cat, but, How do you link a Spin Button to a Cell ?
THANKS
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"B. R.Ramachandran" wrote:

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






rhhince" wrote:

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%........

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

On Sun, 11 Nov 2007 11:49:03 -0800, Learning Excel
wrote:

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

Thanks again Gord Dibben, one more for the road.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Gord Dibben" wrote:

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

On Sun, 11 Nov 2007 11:49:03 -0800, Learning Excel
wrote:

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

Thanks for the feedback.

Keep on Learning<g


Gord

On Sun, 11 Nov 2007 14:12:01 -0800, Learning Excel
wrote:

Thanks again Gord Dibben, one more for the road.