linking a text box to a text box or merged cells

M

Mark

The problem I have is that I need to link a text box in sheet 1 to either
merged cells or a text box on multiple other pages with 1 workbook. I do not
know anything about VBA. I have tried using the Control Toolbar, but am
having trouble with it. I need to enter a line or two then be able to space
down (by hitting enter) and have a line about 2 or 3 spaces down. How can I
do this? If it involves VBA, please give specific instructions, I have
absolutly no clue how to do anything in VBA.

Thanks
 
D

Dave Peterson

How about an alternative?

If you're going to always update the "master" textbox, you can copy it and paste
a picture of that textbox on the other sheets. When that master textbox
changes, so will the pictures of it.

Select the master textbox
edit|copy

off to the other worksheets
Shift-Edit|Paste Picture Link
 
Top