AL_XResearch
asked on
Set formula for Excel textbox directly
I am trying to use a textbox to show the results of a formula that concatenates and calculates various cells. I remember there was a little-known trick in Excel 2003 onwards were you could directly set the formula for a text box (i.e. not a reference or defined name).
To be clear I don't want to set the formula in a hidden cell and then link the textbox to a cell. There is a way to set the formula directly for the textbox but for the life of me I can't remember or discover how to do it.
I also do not want to use 'paste picture link' to show the value from a hidden cell.
If someone would jolt my memory I would be most grateful.
Thanks in advance.
To be clear I don't want to set the formula in a hidden cell and then link the textbox to a cell. There is a way to set the formula directly for the textbox but for the life of me I can't remember or discover how to do it.
I also do not want to use 'paste picture link' to show the value from a hidden cell.
If someone would jolt my memory I would be most grateful.
Thanks in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It was my mistake and it is not possible to do what I was asking.
ASKER