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
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