Text on userform conditionally appearing if vlookup finds reference

[Julesdude]

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!

[Julesdude]

...I should probably say too that I don't want the vlookup to be executed with a commandbutton. I want it to be live and in real time with the input from textbox 1 if you see what I mean. Can anyone help???