Hi,



Then, one possibility could be, you right click your spin control, when
selected, and with the "Format Control" link it to a cell on another sheet.
With the macro assign to the spin control read the value of that cell do
what you like according to the value.



Hope it's help.


--
JP

http://www.solutionsvba.com


"John C." wrote in message
...
I am not able to use the Control Toolbox to create the
spin control, only the Forms Toolbar allows the spin
control to be formed.

I understand what you refer to for the module sheet should
show the control and associated properties, but creating
it from the Forms Toolbar does not present this
information.

Any other ideas?


-----Original Message-----
Hi,



If you make your spin control with the control toolbox,
you then have, in
the module of that sheet, the possibility to add code for
this control, like
that:



Private Sub SpinButton1_Change()

Range("a1").Value = SpinButton1.Value

End Sub


--
JP

http://www.solutionsvba.com


"John C" wrote in message
...
I have placed a spin button on a chart. I am unable to
capture/define what I want the spin control to perform
for
up/down. I can only assign a macro to the control.
It's
acting like a button and not a spin control.

How do I capture whether the control was pressed up or
down?


.