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