| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell Link on Spin Button Form Control | Excel Discussion (Misc queries) | |||
| User form and Command button | Excel Discussion (Misc queries) | |||
| use a button to open a user form? | Excel Discussion (Misc queries) | |||
| A "previous" button on a user form | Excel Discussion (Misc queries) | |||
| User Form Button Code | Excel Programming | |||
Linear Mode
