Message Box Based on Multiple Criteria

[rodl66]

Please bear with me as I explain what I have going on, thank you.

I have a workbook with multiple tabs:
Master tab includes employee information such as ID, name, a barcode, issue/expiration date, and a revoked column.
I have tabs for each week of the month which have Time In/Time Out, Name and Revoked

The plan for this is the employees have a badge with various bits of info including the barcode that has been generated from the Master spreadsheet. When the employee arrives to the work site, the correct weekly tab is open and the first or next open Name cell is active. When the employee's badge is scanned, it will populate the date and time in or out as well as their name. If an employee has been terminated or their badge has been revoked, the "Revoked" cell in the row with their information has been set to "YES".

Here's where the funky part is that I cannot figure out...

What I want to happen is the badge is scanned, it looks for that barcode on the Master sheet, then checks to see if the Revoked cell is set to "YES", if so, I need a message box to appear informing the person scanning that the worker is not authorized onto the work site and to confiscate the badge. Once this has been done, they click OK and the same empty cell is active since it was not populated by a valid scanned badge.

Master sheet info:
Column A = Employee ID Number
Column B = Employee Name
Column C = Auto-generated code 128 barcode
Column J = Revocation YES or NO

Week 1 Attendance sheet info:
Column A = Time In/ Time Out
Column B = Employee Name
Column C = Badge Revoked

I stand by to clarify anything I've muddled and thank you very much!

 

[rodl66]

I guess I've stumped the gurus or they just don't want to help.

 

[rodl66]

Here is my master sheet, after being populated, if someone's badge gets revoked, the appropriate employee will have I? marked as YES

When the employee gets to the work site, the next open column B cell will be active, their badge will be scanned and the corresponding column A cell will be populated with the date and time, then B will be populated with their employee number and name. What is needed is as soon as the badge is scanned, it will check the Revoked cell for that particular employee from the Master sheet. If Revoked is set to YES, it will not populate the cells in the weekly sheet, but will instead generate a pop up box stating, "This badge has been revoked! Please confiscate and direct the employee to leave the site"

 

[rodl66]

Well, this has been reassuring. I guess I'll look for help elsewhere.

 

[Fluff]

Please do not mark a post that doesn't contain a solution as the solution. Thanks