Text box referencing cell

Hi,

Is there any way of linking a textbox to a textbox on another sheet?
i.e copying whatever is in the first?


---
Message posted from http://www.ExcelForum.com/

The easiest thing to do is to link both to the same cell.

Select a drawing commandbar textbox so its border is highlighted but
there's no blinking cursor, click in the formula bar, press the Equals
key, and select the link cell with the mouse.

If you use a textbox from the Controls Toolbox, type the cell address
into the LinkedCell property of the textbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ajw150 wrote:

Hi,

Is there any way of linking a textbox to a textbox on another sheet?
i.e copying whatever is in the first?


---
Message posted from http://www.ExcelForum.com/