In my spreadsheet, I prompt the user to enter a code. The code should be 4 characters. The code is then placed into a cell. I know that I can use data validation to make sure the user has only entered 4 characters into the cell. However, I want the VBA code to check for that before it is ever entered into the cell. How can I do so?