Help with Error

[foamcows]

Hey Guys, having an issue with the following code. This is essentially a combination code, the top part is a dropdown code that will let me display the description of a bunch of parts, but when you select one, it puts the part number into the cell.

The second part is to then go and vlookup the data entered into the cell. Everything works fine when I select data from the dropdown in the cells, however, I need this code to not error out when I put something that the vloookup cannot find.

The error I get is runtime error 1004, unable to get the vlookup property of the worksheetfunction class. it then highlights the following line..." desc = Application.WorksheetFunction.VLookup(Target, Application.Range("Stock"), 2, False) 'lookup column 2 in stock

Please Login or Register  to view this content.

[romperstomper]

Perhaps:

Please Login or Register  to view this content.

[foamcows]

perfect! It had a type mismatch error that would popup, but I was able to suppress that by adding an error handling statement prior to the varmatch.

Thanks!