Link to home
Start Free TrialLog in
Avatar of AL_XResearch
AL_XResearchFlag for United Kingdom of Great Britain and Northern Ireland

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.
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AL_XResearch

ASKER

Hi Rgonzo. No as I said I do not want to simply set a reference to a cell which supplies the actual value.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It was my mistake and it is not possible to do what I was asking.