How do I setup a spin button in excel

Gord

thanks for your info I have managed to insert the Spinner button however I
have a list of information in the spread sheet I would like to link to the
button is this possible and how do i go about it.

Thanks for your help

"Gord Dibben" wrote:

> Right-click on a Toolbar and select Forms Toolbar.
>
> Click on the "Spinner" button.
>
> Draw a button on your worksheet.
>
> Right-click on the button and "Format Control"
>
> Set your parameters and define a cell that the spinner will affect.
>
> Gord Dibben Excel MVP
>
> On Fri, 19 Nov 2004 06:11:01 -0800, Andy K <Andy >
> wrote:
>
> >How do I setup a spin button
>
>

Andy

Unsure what your needs are, but if you use a spin button from the Control
Toolbox you can have code behind the button.

Private Sub SpinButton1_SpinDown()
For Each cell In ActiveSheet.Range("A9:A18")
cell.Value = cell.Value - 2
Next
End Sub


Private Sub SpinButton1_SpinUp()
For Each cell In ActiveSheet.Range("A9:A18")
cell.Value = cell.Value + 2
Next
End Sub

For more options, see VBA Help on "spinbutton"

Gord Dibben Excel MVP

On Fri, 26 Nov 2004 07:33:04 -0800, Andy K >
wrote:

>Gord
>
>thanks for your info I have managed to insert the Spinner button however I
>have a list of information in the spread sheet I would like to link to the
>button is this possible and how do i go about it.
>
>Thanks for your help
>
>"Gord Dibben" wrote:
>
>> Right-click on a Toolbar and select Forms Toolbar.
>>
>> Click on the "Spinner" button.
>>
>> Draw a button on your worksheet.
>>
>> Right-click on the button and "Format Control"
>>
>> Set your parameters and define a cell that the spinner will affect.
>>
>> Gord Dibben Excel MVP
>>
>> On Fri, 19 Nov 2004 06:11:01 -0800, Andy K <Andy >
>> wrote:
>>
>> >How do I setup a spin button
>>
>>