Hi Experts,
I have a macro which is working today but I need to add one more condition to trigger message pop up to alert user that mandatory fields are not filled.
Condition: Check column F starting from cell F17 to Range("F" & Rows.Count).End(xlUp) and if any cell in this range is not null/not empty then show a message and also restrict saving of file.
In macro below, range of cell which need to be check with additional condition is Range 1 ("I5:I11") and Range 2 ("N8:N10").
If any of the cells in range F17 to last row is non empty then check Range 1 and Range 2 if mandatory fields are missing; if any of the fields are missing then restrict save and show message (answer 2). I had similar condition in the bottom for checking with variable j & k but when I try to club this with variable i & l it is not working and showing error.
For variable i & l: restrict save and show answer 2 (without asking to save or not) - this need to be adapted for new condition
For variable k: same message as in macro (already working today)
For variable l: same message as in macro with permission to save o r not (already working today)
Thanks in advance !
Regards
Bookmarks