It goes in the Change event procedure of the SpinButton control.
E.g,

Private Sub SpinButton1_Change()
Me.TextBox1.Text = CStr(Me.SpinButton1.Value)
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Rebecca" wrote in message
...
Thanks!
Does this goes in control source for the textbox?


"Bob Phillips" wrote:

Textbox1.Text = CStr(Spinbutton1.Value)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rebecca" wrote in message
...
Hello to all
I have a user form with textBox1 and SpinButton1. How do I
lnk the button
to the text box?
Thanks