by Sisyphus » Sun May 01, 2016 2:33 am
Perhaps it's just the typo in the function's name. Vlooup is missing a k.
Otherwise, look at the data type of the lookup value. Tbx.Value returns a string, even though it appears to be numeric. If you have numbers in column A, that could be the reason, and converting the Tbx.Value to a numeric value could be the cure.
As a matter of principle, I suggest splitting the final line of code into several components for testing purposes so that you can see where the error occurs. Start by testing the VLookup function on the worksheet. Then assign the Tbx.Value to a variable and issue the lookup to a MsgBox or Immediate Window. Once everything works fine you can put it back into a single line of code.
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)