Inserting last non-blank cell into a text box

[janabanana]

I have tried all of the LOOKUP formulas I could find and cannot get the
formulas to work with a text box.
I keep getting this message:
"The text you entered is not a valid reference or defined name."
How do I get the text box to recognize that it is a formula?

 

[Gary Brown]

The TextBox has a property called 'LinkedCell'. Say the textbox covers cells
B1 to C2. Put 'B1' or 'B2' or 'C1' or 'C2' in the LinkedCell property.
Now reference that LinkedCell in your formulas.

 

[janabanana]

other way around.
the text box is my finished product.
i want the text box to display the contents of a single cell on another sheet.
i can type in the formula:
=Sheet2!A1
in the formula bar (after i have clicked on the text box) and i don't have a
problem.

but when I type anything more complex, like the LOOKUP function it doesn't
like it.

 

[T. Valko]

see your other post