Changing Spinbutton Max/Min with Option Button

[3link]

I have a spin button (active x) with variable max/min values that I wish to change depending on the selection of any of three option buttons (form controls). I can't seem to write a macro to make the max/min of the spin button change when one of the three buttons are clicked. I have tried:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>

 [/FONT][/COLOR]
[COLOR=black][FONT=Verdana]Sub OptionButton155_Click()[/FONT][/COLOR]
[FONT=Verdana][COLOR=black]With SpinButton1[/COLOR][/FONT]
[FONT=Verdana][COLOR=black]       .Min = 0[/COLOR][/FONT]
[FONT=Verdana][COLOR=black]       .Max = 4<o:p></o:p>[/COLOR][/FONT]
[COLOR=black][FONT=Verdana]       End With[/FONT][/COLOR]
[FONT=Verdana][COLOR=black]End Sub<o:p></o:p>[/COLOR][/FONT]

<o></o>
<o></o>
When I attempt to run this macro, I get an error: "Run-time error '424: Object required." Is there another way to achieve the desired effect?<o></o>

 

[p45cal]

try:
With ActiveSheet.SpinButton1

 

[3link]

Thank you! That did it!