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.