The attached workbook has combo box that employees choose their name from and then enter their password. If they enter their password correctly then their name goes into the combo box as well as two other areas. If they for some reason enter an incorrect password then the box remains empty. What I need to figure out(and have failed terribly so far) is 2 things. 1) if they enter and incorrect password the combo box stays empty but it still enteres their name in the additional cells. I want to block it from entering their name if a incorrect password is entered. 2) I want to eliminate entering their name in to the same cell range more than once. as you can see over around cell P53 I have it broken up into lines 1-6. I do not want it to populate a duplicat name within the same line number. also starting at line V51 I don't ever want it to populate a name more than once.
9675A.xlsm
Password for the VBA project is Touchdown_97
Bookmarks