ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   movable formula (https://www.excelbanter.com/excel-programming/295839-movable-formula.html)

choice

movable formula
 
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

Juan Pablo González

movable formula
 
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" wrote in message
...
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




All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com