Link Text Boxes on Form?

[Joyce]

Hi all,

I have create a multi-sheet workbook that contains a variety of related forms.

I would like the content of a text box entered on one sheet to automatically
populate a text box on another sheet.

Any suggestions?
Thanks!

 

[Joyce]

Thank you for your response.

I actually did know that I can do that, but these are structured forms that
users fill in, and we want them to fill in a variety of text boxes, select
radio buttons and check boxes, etc.

In this way, they would have to type the information in the cell for it to
appear in the text boxes. We really wanted them to type in one text box and
automatically have a text box on another page populate with the same data.

I am guessing this cannot be done?

Thanks again.

 

[Joyce]

No problem. I appreciate your reponses.

I think I can link and then disable the 2nd text box. However, when this
happens, it becomes gray and not very readable.

Would you know how to make the text of a disabled text frame remain black?

Thanks again.

It can be done... However, I'm not yet equipped with VBA programming.

Sorry...

Thank you for your response.

I actually did know that I can do that, but these are structured forms that
users fill in, and we want them to fill in a variety of text boxes, select
radio buttons and check boxes, etc.

In this way, they would have to type the information in the cell for it to
appear in the text boxes. We really wanted them to type in one text box and
automatically have a text box on another page populate with the same data.

I am guessing this cannot be done?

Thanks again.

If you're using the same cell value/text to those text box then I would
suggest to Name that cell. Next is assign that Name as the value of the text

[quoted text clipped - 10 lines]

Any suggestions?
Thanks!

 

[Jacob Skaria]

Check your other post ...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.
You can replicate the same for sheet2 textbox change event if you need.....

Private Sub TextBox1_Change()
Sheets("sHEET2").TextBox1.Text = TextBox1.Text
End Sub

If this post helps click Yes
---------------
Jacob Skaria

No problem. I appreciate your reponses.

I think I can link and then disable the 2nd text box. However, when this
happens, it becomes gray and not very readable.

Would you know how to make the text of a disabled text frame remain black?

Thanks again.

It can be done... However, I'm not yet equipped with VBA programming.

Sorry...

Thank you for your response.

I actually did know that I can do that, but these are structured forms that
users fill in, and we want them to fill in a variety of text boxes, select
radio buttons and check boxes, etc.

In this way, they would have to type the information in the cell for it to
appear in the text boxes. We really wanted them to type in one text box and
automatically have a text box on another page populate with the same data.

I am guessing this cannot be done?

Thanks again.

If you're using the same cell value/text to those text box then I would
suggest to Name that cell. Next is assign that Name as the value of the text
[quoted text clipped - 10 lines]
Any suggestions?
Thanks!

 

[Joyce]

I hesitated with other post, but thought perhaps the answer may or may not be
in code.

I'm wondering if there's a way to deactivate the 2nd text box without its
content being grayed out and the scroll bar still working, but just not
allowing the users to modify the content...

Thanks very much for your assistance.

Check your other post ...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.
You can replicate the same for sheet2 textbox change event if you need.....

Private Sub TextBox1_Change()
Sheets("sHEET2").TextBox1.Text = TextBox1.Text
End Sub

If this post helps click Yes
---------------
Jacob Skaria

No problem. I appreciate your reponses.

I think I can link and then disable the 2nd text box. However, when this
happens, it becomes gray and not very readable.

Would you know how to make the text of a disabled text frame remain black?

Thanks again.

It can be done... However, I'm not yet equipped with VBA programming.

Sorry...


Joyce wrote:
Thank you for your response.

I actually did know that I can do that, but these are structured forms that
users fill in, and we want them to fill in a variety of text boxes, select
radio buttons and check boxes, etc.

In this way, they would have to type the information in the cell for it to
appear in the text boxes. We really wanted them to type in one text box and
automatically have a text box on another page populate with the same data.

I am guessing this cannot be done?

Thanks again.

If you're using the same cell value/text to those text box then I would
suggest to Name that cell. Next is assign that Name as the value of the text
[quoted text clipped - 10 lines]
Any suggestions?
Thanks!

 

[Jacob Skaria]

Solution posted for the other post... Joyce a small suggestion..It is easy
when you list down your requirements in one shot...coz there could be better
solutions..

Cheers...Take care

I hesitated with other post, but thought perhaps the answer may or may not be
in code.

I'm wondering if there's a way to deactivate the 2nd text box without its
content being grayed out and the scroll bar still working, but just not
allowing the users to modify the content...

Thanks very much for your assistance.

Check your other post ...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.
You can replicate the same for sheet2 textbox change event if you need.....

Private Sub TextBox1_Change()
Sheets("sHEET2").TextBox1.Text = TextBox1.Text
End Sub

If this post helps click Yes
---------------
Jacob Skaria

No problem. I appreciate your reponses.

I think I can link and then disable the 2nd text box. However, when this
happens, it becomes gray and not very readable.

Would you know how to make the text of a disabled text frame remain black?

Thanks again.

:

It can be done... However, I'm not yet equipped with VBA programming.

Sorry...


Joyce wrote:
Thank you for your response.

I actually did know that I can do that, but these are structured forms that
users fill in, and we want them to fill in a variety of text boxes, select
radio buttons and check boxes, etc.

In this way, they would have to type the information in the cell for it to
appear in the text boxes. We really wanted them to type in one text box and
automatically have a text box on another page populate with the same data.

I am guessing this cannot be done?

Thanks again.

If you're using the same cell value/text to those text box then I would
suggest to Name that cell. Next is assign that Name as the value of the text
[quoted text clipped - 10 lines]
Any suggestions?
Thanks!

 

[Joyce]

Point taken. You're absolutely right.

Please accept my sincere thanks for all of your help. I posted my thanks on
other post as well.

Solution posted for the other post... Joyce a small suggestion..It is easy
when you list down your requirements in one shot...coz there could be better
solutions..

Cheers...Take care

I hesitated with other post, but thought perhaps the answer may or may not be
in code.

I'm wondering if there's a way to deactivate the 2nd text box without its
content being grayed out and the scroll bar still working, but just not
allowing the users to modify the content...

Thanks very much for your assistance.

Check your other post ...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.
You can replicate the same for sheet2 textbox change event if you need.....

Private Sub TextBox1_Change()
Sheets("sHEET2").TextBox1.Text = TextBox1.Text
End Sub

If this post helps click Yes
---------------
Jacob Skaria


:

No problem. I appreciate your reponses.

I think I can link and then disable the 2nd text box. However, when this
happens, it becomes gray and not very readable.

Would you know how to make the text of a disabled text frame remain black?

Thanks again.

:

It can be done... However, I'm not yet equipped with VBA programming.

Sorry...


Joyce wrote:
Thank you for your response.

I actually did know that I can do that, but these are structured forms that
users fill in, and we want them to fill in a variety of text boxes, select
radio buttons and check boxes, etc.

In this way, they would have to type the information in the cell for it to
appear in the text boxes. We really wanted them to type in one text box and
automatically have a text box on another page populate with the same data.

I am guessing this cannot be done?

Thanks again.

If you're using the same cell value/text to those text box then I would
suggest to Name that cell. Next is assign that Name as the value of the text
[quoted text clipped - 10 lines]
Any suggestions?
Thanks!