In the change event of the spin button, update the textbox with the value of
the spin button

In the initialize event of the userform, change the value of the spinbutton
to 1.

--
Regards,
Tom Ogilvy


"jhahes" wrote in
message ...

How do I get the spin button to control the text box

I want TextNumberOfGames(TextBox) to change when the
SpinNumberOfGames(SpinButton) is clicked up or down.

This is all in a form. I have already set the min, max, and change.

I would also like, if possible for the default to be 1, when the form
opens.


Thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=475931