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

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

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/

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

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

Any other expamples of a spin button out there

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

I have an example of a spin button on my website (Date Time Picker)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"scottnshelly " wrote in
message ...
Any other expamples of a spin button out there?


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