I created an inventory worksheet with userforms. Now I have a problem with VLookup command. I want the name of the item is shown in the "txtName" after I scanned the barcode in the "txt2DBarcode."

The second part of the code is working and can find the name of the item. But if the barcode number does not exist in the Sheet1.Range "A:A" I have debug error instead of showing the message.

Here is the code:

HTML Code: 
Untitled.jpg