Inserting last non-blank cell into a text box

  • Thread starter Thread starter janabanana
  • Start date Start date
J

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?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for specific text within last non blank cell in a range 2
Text from a comment box into a cell 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
First Non-Blank Cell 6
Searching the formula (not the value) for a text string 1
Link text box to a cell 1
Reference to next non-blank cell 5
Last non-blank row 8

Back
Top