Auto-insert Date after Barcode scan

Greetings; I hope one of you knowledgeable people can help me with a problem I have getting the date to auto-fill in Excel. The situation is this. I am working on a spreadsheet that will accept inputs from a scanner. I have solved all issues to date but this one. When one of our product testers has tested a unit and it passes or fails he scans one of two barcodes that has his name and either "pass" or "fail" embedded in it. I would like the next cell in the column to the right to auto-fill the date. The cue to do that would be if anything has been entered in the cells to its left.

If I was to describe the logic it would be something like;

if A1 or B1 contain any characters whatsoever enter date and time in C1
if A2 or B2 contain any characters whatsoever enter date and time in C2
etc. etc.


Thanks in advance for your help.

Cheers
Ron

Hi Abousetta; I inserted the code and tried it but it didn't add the date. I tried two barcodes, one that tabs to the next cell over and one that doesn't. Neither worked. Your efforts are very much appreciated.

Cheers

Right click, view code, Worksheet. Alt-Q, and saved.

That's what mine now looks like. In "general" and "declarations". Still no date.

I don't see my last post so here it is again.

It works fine in your example. Still not working in my spreadsheet though. Also I used A1/B1 as example columns. The actual columns used might be in the F-G-H range when the spreadsheet is finished.

It now works. Thank you..Thank you. My guess is if I change the A:B values to be my column designations then it would work further into the spreadsheet.

Cheers
Ron

Your help is most appreciated.

Cheers
Ron