Slight alteration/addition to my VBA code needed.

Hi @ danbates

You can try adding this line:

Please Login or Register  to view this content.

And changing this:

Please Login or Register  to view this content.

Perhaps you need to Dim the variable Answer as integer

Perhaps I didn't myself clear.

The first change is to insert in your code the line

Please Login or Register  to view this content.

It should go exactly after the line ...For each....

This line by itself has no efect in your code. This is just a "mark" where you will send the action of the code later on.

The second change I suggested is to replace your

Please Login or Register  to view this content.

with the following :

Please Login or Register  to view this content.

If your code was running before the changes, I cannot see why it could not work after this changes.

Perhaps I didn't make myself clear.

The first change is to insert in your code the line

Please Login or Register  to view this content.

It should go exactly after the line ...For each....

This line by itself has no efect in your code. This is just a "mark" where you will send the action of the code later on.

The second change I suggested is to replace your

Please Login or Register  to view this content.

with the following :

Please Login or Register  to view this content.

Again, this two lines have no virtual effect on your code, but having 2 buttons instead of one;
this time if the user clicks on "Cancel" the code remains exactly as before, but if the user clicks on "Retry", the accion returns to where you put the "Jump" line and starts it over again.

If your code was running before the changes, I cannot see why it could not work after this changes.

Hi Dan

Sorry for the late answer, I didn't see your new question

First, I'm glad to know the initial part was solved.
As I don't have your data, I can't see how your code works, I just try to imagine !

When an operator selects their initials, a message box appears with OK and Cancel

From your code, I don't see where this message could come from,
perhaps if you post the workbook.....
If you do so, please don't show sensitive data.

Vicho