That's strange.

I've just created a new workbook, added a userform, added a spinbutton,
added a textbox, copied the code from my last e-mail and ran the form (by
pressing F5)
Worked OK here.

What's you error message?


"Randal W. Hozeski" wrote in message
...

This keeping crashing on me @ the following

Private Sub TextBox1_Change()
dblMyValue = Val(TextBox1.Text)
If dblMyValue = SpinButton1.Min And _
dblMyValue <= SpinButton1.Max Then _
SpinButton1.Value = dblMyValue
End Sub

and is not working? The up/down arrow are not
spinning anymore. any idea why?
My code is working fine, scrollwise I just need
it to stop rounding up.
-Randy-


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!