| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Cell with Content of Text Box
I am trying to display the content of one text box on a form in another form
text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate Cell with Content of Text Box
---Right click the text boxes and set the ControlSource property to the cell
reference for example Sheet1!a1 ---You can directly get the textbox content from another userform Me represent userform2 Me.TextBox1 = UserForm1.TextBox1.Text If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I am trying to display the content of one text box on a form in another form text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate Cell with Content of Text Box
Hello Jacob,
Where would I put the Me.TextBox1 = UserForm1.TextBox1.Text code? I would ideally just like one text box to automatically contain was another one does. "Jacob Skaria" wrote: ---Right click the text boxes and set the ControlSource property to the cell reference for example Sheet1!a1 ---You can directly get the textbox content from another userform Me represent userform2 Me.TextBox1 = UserForm1.TextBox1.Text If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I am trying to display the content of one text box on a form in another form text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate Cell with Content of Text Box
Hope you have tried ControlSource property too....You can place the code in
Initialize event of the second form...The below code is written on userform2 initialize which will assign the textbox1 with the value in textbox1 in userform1 Private Sub UserForm_Initialize() Me.TextBox1 = UserForm1.TextBox2 End Sub If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: Hello Jacob, Where would I put the Me.TextBox1 = UserForm1.TextBox1.Text code? I would ideally just like one text box to automatically contain was another one does. "Jacob Skaria" wrote: ---Right click the text boxes and set the ControlSource property to the cell reference for example Sheet1!a1 ---You can directly get the textbox content from another userform Me represent userform2 Me.TextBox1 = UserForm1.TextBox1.Text If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I am trying to display the content of one text box on a form in another form text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate Cell with Content of Text Box
I think we're having a miscommunication. I apologize. I am designing a
form-like worksheet, but haven't created an actual userform. So, I am simply trying to populate one text box with another's content without userforms. I hope I'm being more clear this time. Thanks "Jacob Skaria" wrote: Hope you have tried ControlSource property too....You can place the code in Initialize event of the second form...The below code is written on userform2 initialize which will assign the textbox1 with the value in textbox1 in userform1 Private Sub UserForm_Initialize() Me.TextBox1 = UserForm1.TextBox2 End Sub If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: Hello Jacob, Where would I put the Me.TextBox1 = UserForm1.TextBox1.Text code? I would ideally just like one text box to automatically contain was another one does. "Jacob Skaria" wrote: ---Right click the text boxes and set the ControlSource property to the cell reference for example Sheet1!a1 ---You can directly get the textbox content from another userform Me represent userform2 Me.TextBox1 = UserForm1.TextBox1.Text If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I am trying to display the content of one text box on a form in another form text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate Cell with Content of Text Box
OK..Now it is clear... You can use the Linked Cell property..
Right click the TextboxPropertiesAganist the Linked cell property type in the cell reference for both the textboxes.. eg: Sheet1!A1 If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I think we're having a miscommunication. I apologize. I am designing a form-like worksheet, but haven't created an actual userform. So, I am simply trying to populate one text box with another's content without userforms. I hope I'm being more clear this time. Thanks "Jacob Skaria" wrote: Hope you have tried ControlSource property too....You can place the code in Initialize event of the second form...The below code is written on userform2 initialize which will assign the textbox1 with the value in textbox1 in userform1 Private Sub UserForm_Initialize() Me.TextBox1 = UserForm1.TextBox2 End Sub If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: Hello Jacob, Where would I put the Me.TextBox1 = UserForm1.TextBox1.Text code? I would ideally just like one text box to automatically contain was another one does. "Jacob Skaria" wrote: ---Right click the text boxes and set the ControlSource property to the cell reference for example Sheet1!a1 ---You can directly get the textbox content from another userform Me represent userform2 Me.TextBox1 = UserForm1.TextBox1.Text If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I am trying to display the content of one text box on a form in another form text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate Cell with Content of Text Box
Using code ..Suppose you have textbox1 in both Sheet1 and sheet2. In Design
mode double click Sheet1 which will open up the code window for Textbox1 . Paste the below code (which is the change event) Any changes made to Sheet1 textbox1 will be reflected in Sheet2 textbox 1. Private Sub TextBox1_Change() Sheets("sHEET2").TextBox1.Text = TextBox1.Text End Sub If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I think we're having a miscommunication. I apologize. I am designing a form-like worksheet, but haven't created an actual userform. So, I am simply trying to populate one text box with another's content without userforms. I hope I'm being more clear this time. Thanks "Jacob Skaria" wrote: Hope you have tried ControlSource property too....You can place the code in Initialize event of the second form...The below code is written on userform2 initialize which will assign the textbox1 with the value in textbox1 in userform1 Private Sub UserForm_Initialize() Me.TextBox1 = UserForm1.TextBox2 End Sub If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: Hello Jacob, Where would I put the Me.TextBox1 = UserForm1.TextBox1.Text code? I would ideally just like one text box to automatically contain was another one does. "Jacob Skaria" wrote: ---Right click the text boxes and set the ControlSource property to the cell reference for example Sheet1!a1 ---You can directly get the textbox content from another userform Me represent userform2 Me.TextBox1 = UserForm1.TextBox1.Text If this post helps click Yes --------------- Jacob Skaria "Joyce" wrote: I am trying to display the content of one text box on a form in another form text box on another sheet. I don't want the users to have to type information in a cell - justs the initial text box. I know I can link cell content to a text box, so I'd ideally like to have the user input data into textbox1, have that display in a cell, then have textbox2 link to the cell so that it populates automatically. Any idea if this is possible? Or any better ideas? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I use a cell content to auto-populate to a header in excel? | Excel Discussion (Misc queries) | |||
| Text box does not populate linked cell | Excel Worksheet Functions | |||
| Content from Text box to Cell | Excel Programming | |||
| Populate First Empty Cell In each Row with Text | Excel Programming | |||
| Populate a cell from a text box. | Excel Programming | |||
Hybrid Mode
