Don't try to make your life so difficult - in a hidden area of the
worksheet, have a 2 cells to do the work - the FIRST textbox is set to
be linked to the first cell. The second cell contains the lookup
formula. The First Textbox is set so that on the Exit event it sets
the text of the Second textbox to the value of the second cell (hope
that's clear!). DON'T link the second cell though, as it would change
the formula to the value - which isn't what you want!


jeffbert wrote:
I have a textbox that shows a number. I need another text box on the same
sheet to lookup that number and show the corresponding description that
relates to that number.

EX:

974 - (Text Box 1)
Bob - (Text box 2)


Text box 2 looks up the value of text box 1 in a table and returns the value
in column 2.