Spin button problem

[gwa1982]

Hi,

I have an issue with a piece of code I am trying to attach to a spin button which will allow me to cycle through scenarios.

Sub Scenario_Change()


With sheets("General inputs")


With Selection
.Value = 0
.Min = 0
.Max = 3
.SmallChange = 1
.LinkedCell = "General inputs!$C$15"
.Display3DShading = True
End With
End With
End Sub


The VBA editor is saying that it doesn't accept the min value at zero and is delivering a runtime error 438. Can any one explain what I am doming wrong here?

The Macro is designed to use a spin button to hang values in a cell in a different work sheet called General inputs.

Many thanks for any help.

Regards
Geoff

 

[diddi]

"selection" is not a variable used with spinbuttons, nor is it the name of a control.
you seem to be setting properties of the control here rather than using it to branch your code?