Hi there to all!

A simple but tricky problem. I'm trying to build a userform with a text box but I'm trying to do something a bit tricky. When a user enters a code into textbox1 I need a vlookup function to use this value to reference worksheet A in, say, column D and return text in column E. Here's the tricky bit though. If there is a code found, I need text to appear just underneath the textbox with the vlookup return value. If nothing is found then it should say this too - like 'code not found'.

Can anyone help please? Thanks!