Hi,

Im very new to all this so forgive me if this sounds stupid!

I have made my first ever user form and this works well and inserts data
into a worksheet without problems.

A lot of the data that is input may already be on another worksheet. Can I
add a textbox and command button to allow the user to specify a reference
number? Then have the app look on the other worksheet for the reference and
use the values it finds to autofill some of the userform text boxes, in much
the same way that I could use Vlookup on the worksheet itself?

Thanks in advance for any help.

regards

John