Vba textbox

[faheem354]

Hi,

I am developing bar-code reader by VBA but i have some issues, any one can help me.

A. I have 8 textbox in a userform1
1. Barcode 2. Brand 3. Size 4. Length 5. Height 6. Width 7. Weight 8. Crop


I want to scan a bar code in barcode (Textbox) and how can use vlookup type formula in all textbox mean i have all barcodes data in sheet1 and the VBA match the bacrcode and show me value if matched in all textboxes

 

[faheem354]

Please tell me i am stuck please help me.

 

[faheem354]

please help