How do I setup a spin button in excel

G

Gord Dibben

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
 
A

Andy K

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
 
G

Gord Dibben

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
 
Top