User Form Spin Button
 

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

User Form Spin Button
 

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

User Form Spin Button
 

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

User Form Spin Button
 

Rebecca,

Oh no. Unfortunately, you have to manage it.

It depends upon your design. It could be done in the spinner control, or in
a commandbutton. As I say, it depends on what you are doing.

--

HTH

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


"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

User Form Spin Button
 

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

User Form Spin Button
 

Thanks!

"Chip Pearson" wrote:

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