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