VBA Inventory Using Barcode Scanner - That Counts if any Code Scanned

[mohmadhabib]

Hello
I Would like to thank all of the Amazing Materials in this Forums and It helped me a lot

At the Beginning I Have some Experience in Excel but not that Could be Mentioned Compared with you guys!

I have this Sheet from an amazing Saver Called Robert Bliss, First I would thank him for this, But Second I would like to make an Simple Modification to the Code as Below:
1. If the Scanned Code was not in the A Column then Search in the B or C Column

Here is the Code I Have Used in the Sheet

Please Login or Register  to view this content.

And That's IT

Thanks in Advance

[rollis13]

Changing these 3 marked lines of code should do the trick:

Please Login or Register  to view this content.

[nankw83]

Hi mohmadhabib & welcome to the forum,

Try changing the below lines ...

Please Login or Register  to view this content.

[mohmadhabib]

So Many Thanks for your Amazing Help, rollis13 & nankw83

That worked as it should be With me

[rollis13]

Glad we were able to help .