You have a couple of different problems here.
First of all the code you showed above does not exist in this file.
The user form collects a reason for rejection if the value in AA is "Rejected". However, the data validation in column AA does not allow the user to enter "Rejected", only "Approved". Second, AA is for Level 1, and there is no column for "Level 1 Reason for Rejection". AC is "Level 1 Approver", and AE is "Level 2 Approval Date". AG is "Level 2 Reason for Rejection", but there isn't one for Level 1.
I have added a Submit button to the form to explicitly close it. The user can close it with the X but it is not intuitive that is what they are supposed to do. There is a button there but it's just a graphic, and there is no code associated with it so nothing will happen when you click it. No idea what you had in mind there.
I have corrected your code in the file but you still need to sort out exactly which column you want the result to go in.
Last, I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.
Bookmarks