Can you link a text boxt from one sheet to another in excel 2003 and if so, how?
J jgz45 Apr 28, 2008 #1 Can you link a text boxt from one sheet to another in excel 2003 and if so, how?
M Max Apr 29, 2008 #2 jgz45 said: Can you link a text box from one sheet to another in excel 2003 and if so, how? Click to expand... Draw a textbox in Sheet1 With the box selected, click inside the formula bar, enter, say: =Sheet2!A1 The box will show the contents of Sheet2's A1
jgz45 said: Can you link a text box from one sheet to another in excel 2003 and if so, how? Click to expand... Draw a textbox in Sheet1 With the box selected, click inside the formula bar, enter, say: =Sheet2!A1 The box will show the contents of Sheet2's A1
E Earl Kiosterud Apr 29, 2008 #3 With a cursor in the text box, click in the formula bar, type =, then switch to the target sheet, click the cell, and press Enter.
With a cursor in the text box, click in the formula bar, type =, then switch to the target sheet, click the cell, and press Enter.
