VLookup in UserForm VBA issues

Hello All,

I'm a self-taught VBA novice (thanks to excellent sites such as Mr. Excel) and I am working on creating a GUI for a spreadsheet I've been keeping of units my team ships out. In my spreadsheet, I have a formula that performs a Vlookup for the model number of a unit shipped if the part number is entered. This formula looks at a different worksheet and returns the values requested. I'm trying to translate this into the VBA Userform but keep getting the 1004 error and Excel keeps crashing. Maybe you guys could help me out? Here's the code I'm working with:

Please Login or Register  to view this content.

Basically, I have a text field called CompanyPN where I'm entering my part number. I want to populate another text field, ModelNumber, based on these results in my UserForm. Please help if you can!

Thanks,
Alex

Alex

Can you upload a sample workbook?