ceeejayy
04-25-2007, 08:45 AM
In Excel, there are:
1) A text-containing Autoshape Text Box ("tbWorksheet") residing in a Worksheet .
2) A vba object textbox ("tbUserForm") residing in an attached UserForm.
I wish to link tbWorksheet and tbUserForm such that text in tbWorksheet appears in tbUserForm.
I have tried various linkages utilizing control source property, tb__.Text, tb__.Value, etc but can't make it work. Tr?s frustrant.
Any assistance is greatly appreciated. Thanks in abundance.
1) A text-containing Autoshape Text Box ("tbWorksheet") residing in a Worksheet .
2) A vba object textbox ("tbUserForm") residing in an attached UserForm.
I wish to link tbWorksheet and tbUserForm such that text in tbWorksheet appears in tbUserForm.
I have tried various linkages utilizing control source property, tb__.Text, tb__.Value, etc but can't make it work. Tr?s frustrant.
Any assistance is greatly appreciated. Thanks in abundance.