| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting data into next blank cell down in next sheet | Excel Worksheet Functions | |||
| Macro - Inserting text to a cell already containg text | Excel Worksheet Functions | |||
| Macro - Inserting text to a cell already containg text | Excel Discussion (Misc queries) | |||
| Split a Blank Cell into Two (Without Inserting Cell) | Excel Discussion (Misc queries) | |||
| Split a Blank Cell into Two (Without Inserting Cell) | Excel Discussion (Misc queries) | |||
Linear Mode
