Spin Button...

S

scottnshelly

i've never seen anycode or tips or anything for the spin button. wha
exactly is that, when/where should i use that. do you have an exampl
of a code that will make it work
 
G

Greg Koppel

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
 
S

scottnshelly

Thanks a lot Greg. i've just always been curious about that one. I
seems like i've seems like i've seen examples for all of them excep
the spin button.
Any other examples???
Thanks
 
Top