Hi Scott,

I have used it in the past to resize a UserForm

Private Sub SpinButton1_Change()
If UserForm1.SpinButton1.Value = 2 Then
MsgBox UserForm1.Zoom
UserForm1.Zoom = UserForm1.Zoom * 1.1
MsgBox UserForm1.Zoom
End If
If UserForm1.SpinButton1.Value = 1 Then
MsgBox UserForm1.Zoom
UserForm1.Zoom = UserForm1.Zoom * 0.9
MsgBox UserForm1.Zoom
End If
End Sub

HTH, Greg

"scottnshelly " wrote in
message ...
i've never seen anycode or tips or anything for the spin button. what
exactly is that, when/where should i use that. do you have an example
of a code that will make it work?


---
Message posted from http://www.ExcelForum.com/