Hi,
I'm trying to prevent a excel form being saved before certain cells are filled in. Need help in VBA query. Attaching my sample form.
Requirement 1 - If E1 is not NULL, then the user should enter the cell F1 compulsorily and sheet should return an error message as "Enter Work Status". Similarly for the entire column within the sheet and rest of the sheets in the workbook.
Requirement 2 - If F1 is "CLOSED", then the user should enter the cell G1 compulsorily and sheet should return an error message as "Enter End Status". Similarly for the entire column within the sheet and rest of the sheets in the workbook.
Is this possible? Any help would be greatly appreciated.
Important - The form is protected using "Protect Sheet" option.
Bookmarks