MACRO (Scanning 2 barcodes for each row) - Need ASAP

[Bluesguy07]

Good morning gurus,

I have a problem that I need some assistance with. I need to be able to scan into an input box 2 variables. The first box will be a barcode scan of a serial number, and the second barcode scan will be a weight. I need for the 1st scan (Serial Number) to be in column A, starting Cell A2, and for the 2nd scan (Weight) to be in column B, starting Cell B2. The order of the scans will be Column A, Column B, Column A, Column B, etc. (I hope that makes sense). Essentially we will scan one unit, and then scan the weight, and then move on to the next. I will then add the pass/fail formula to Column C. Example Below. If you can get me started on this macro, I can adjust the variables as needed. Please let me know if you need any additional details. I need this within the next couple of hours if possible.

Column A | Column B | Column C
5646214 | 342 | Fail
4562145 | 402 | Pass

 

[Bluesguy07]

Since I can't edit my original post, here's a new idea.

Instead of doing this with just an input box macro, I created a form. However, I'm clueless as to how to make the form actually work. Text Box 1=Serial Number, Text Box 2 = Weight.

I need for the Serial Number to be put in the first available cell in Column A, and the Weight to be put in the first available cell in Column B.

I then added two buttons. One to add another set, and then the second to close the form.

Any help would be greatly appreciated as I've never used forms before, and I can't find anything specifically for this.

 

[Neketh]

Hi Bluesguy did you get the resolve to this post, I have similar problem requiring 3 columns of data.