Need Help with Text Box in Excel 2008

[cyberxan]

I am having trouble and cannot find a solution...so far! I have a text box
in worksheet1 and I need that information to automatically go to a text box
in worksheet 2. I cannot find a way to make that carry over...I see that
in the box that shows the cell#, it says TextBox 6, but cannot do a formula
in worksheet two that it understands. I tried ='Worksheet1'!TextBox6 ,
but that did not work.

I made a macro for this in an older version of Excel, but it won't work
since Excel has eliminated macros from the new version.

Thank you for any help attempts.

Cyberxan

 

[CyberTaz]

Sorry, can't happen. There's no provision in Excel for linking text boxes.
You can create a formula for the object that references a cell but an object
can't refer to another object without VBA.

 

[cyberxan]

Yeah I was coming to that realization quickly...so is there any automated way
to replicate the text?
I did a macro on my PC with an older version of Excel this morning which
worked perfectly...I can't imagine why they would create a later version that
cannot do any of these tasks!

Basically I have two identical worksheets in all ways except one column is
different. So I went to Worksheet one and in every cell I typed in:
='Worksheet1'!Cell# so that anything I do in worksheet 1 is automatically
carried over to worksheet 2.

Now I have two text boxes that have all the job specifications.
I've tried to highlight an area and merge the rows and text wrap so that the
user can type in the info. But it does not work and I tried Row Autofit and
again it does not work. Any ideas?

Thanks Again!

Sorry, can't happen. There's no provision in Excel for linking text boxes.
You can create a formula for the object that references a cell but an object
can't refer to another object without VBA.

I am having trouble and cannot find a solution...so far! I have a text box
in worksheet1 and I need that information to automatically go to a text

[quoted text clipped - 13 lines]

Cyberxan

 

[cyberxan]

Your reply was cut off...I'm interested in any ideas!

Yeah I was coming to that realization quickly...so is there any automated way
to replicate the text?
I did a macro on my PC with an older version of Excel this morning which
worked perfectly...I can't imagine why they would create a later version that
cannot do any of these tasks!

Basically I have two identical worksheets in all ways except one column is
different. So I went to Worksheet one and in every cell I typed in:
='Worksheet1'!Cell# so that anything I do in worksheet 1 is automatically
carried over to worksheet 2.

Now I have two text boxes that have all the job specifications.
I've tried to highlight an area and merge the rows and text wrap so that the
user can type in the info. But it does not work and I tried Row Autofit and
again it does not work. Any ideas?

Thanks Again!

Sorry, can't happen. There's no provision in Excel for linking text boxes.
You can create a formula for the object that references a cell but an object

[quoted text clipped - 5 lines]

 

[cyberxan]

SORRY I SEE IT NOW. Thank you again

Your reply was cut off...I'm interested in any ideas!

Yeah I was coming to that realization quickly...so is there any automated way
to replicate the text?

[quoted text clipped - 19 lines]

 

[CyberTaz]

The only option I can think of is to put the text content into a regular
cell somewhere in the workbook then formula-link each text box to that cell.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Yeah I was coming to that realization quickly...so is there any automated way
to replicate the text?
I did a macro on my PC with an older version of Excel this morning which
worked perfectly...I can't imagine why they would create a later version that
cannot do any of these tasks!

Basically I have two identical worksheets in all ways except one column is
different. So I went to Worksheet one and in every cell I typed in:
='Worksheet1'!Cell# so that anything I do in worksheet 1 is automatically
carried over to worksheet 2.

Now I have two text boxes that have all the job specifications.
I've tried to highlight an area and merge the rows and text wrap so that the
user can type in the info. But it does not work and I tried Row Autofit and
again it does not work. Any ideas?

Thanks Again!

Sorry, can't happen. There's no provision in Excel for linking text boxes.
You can create a formula for the object that references a cell but an object
can't refer to another object without VBA.

I am having trouble and cannot find a solution...so far! I have a text box
in worksheet1 and I need that information to automatically go to a text

[quoted text clipped - 13 lines]

Cyberxan