G Guest Apr 21, 2004 #1 is it possible to put a formula in a text box, or something like that, where the value will change, but i can move the box to where i need it
is it possible to put a formula in a text box, or something like that, where the value will change, but i can move the box to where i need it
J Juan Pablo Gonzalez Apr 21, 2004 #2 You can link a textbox to a particular cell. Do this... let's say you're formula is in A1 =SUM(B1:B100) now, draw a textbox. Select it, now, in the formula bar, type =A1 The textbox will display the result of the formula, which you can now move wherever you want to.. -- Regards, Juan Pablo González choice said: is it possible to put a formula in a text box, or something like that, Click to expand... where the value will change, but i can move the box to where i need it
You can link a textbox to a particular cell. Do this... let's say you're formula is in A1 =SUM(B1:B100) now, draw a textbox. Select it, now, in the formula bar, type =A1 The textbox will display the result of the formula, which you can now move wherever you want to.. -- Regards, Juan Pablo González choice said: is it possible to put a formula in a text box, or something like that, Click to expand... where the value will change, but i can move the box to where i need it
