Inserting last non-blank cell into a text box
 

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?

--
jana

Inserting last non-blank cell into a text box
 

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.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"janabanana" wrote:

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?

--
jana

Inserting last non-blank cell into a text box
 

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.

--
jana


"Gary Brown" wrote:

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.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"janabanana" wrote:

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?

--
jana

Inserting last non-blank cell into a text box
 

see your other post

--
Biff
Microsoft Excel MVP


"janabanana" wrote in message
...
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?

--
jana