I am running an InputBox, and depending on what password the user enters, it executes certain macros. However, if the user does not enter anything or enters an invalid password, I want it to bring up an error message using a msgbox. I have the accepted passwords in a row on a separate worksheet. How can I reference that row with an "If ...Then" statement to determine whether the password entered is valid? Furthermore, if the cancel button is selected, how can I get the entire workbook to close?