Excel 2007 : [SOLVED] Userform crashing with copied and pasted data

Hi All,

I'm pretty new to using Excel and VBA but have managed to create 2 workbooks with a userform attached to each. The workbooks are Quotes and Production List.

Both have identical columns and formatting etc so once a quote has been entered onto the Quote sheet and accepted I can copy that row of information and paste it into the Production list.
The Production list uses a Userform to produce a Job sheet. The Job sheet has 30 text boxes that are populated when the quote number is selected from a combobox.
Now this is where the problem happens.....
When i select the quote number of the copied data the userform crashes with an error message. Runtime error '1004': Unable to get the Vlookup property of the WorksheetFunction class.
If I enter the exact same data into the Production List manually the Userform is quite happy to display all the data. The crash only happens with the copy & pasted data.
The cell data is made up of stuff like customer information, phone numbers, job descriptions.

I hope you can suggest a solution as it's driving me insane.

Thanks in advance.

Yep of course. What's the best way as can't see anyway of attaching a file to a post?

The data is mixed. Most of it is words but i also need numbers for sizes and phone numbers etc.

Here's the two workbooks (i hope).

Hope this helps.

Originally Posted by romperstomper

Try this version of your production sheet.

Thank you so much mate, that's perfect.