Hi,
I have a spreadsheet where there are multiple cells, that need to completed before being submitted. I have written the code so a MsgBox will pop up when submitted if the cells are empty, but it will pop up one for each cell separately. I would prefer that only one MsgBox would pop up, identifying which cells need to be completed but I am not sure how to combine them so only the empty cells are advised in the MsgBox.
The Subs I have written are below:
Eventually, I will probably roll the above Subs into one (e.g. DocChk) and run it as part of the Submit code but I am still relatively inexperienced so trying to keep it simple.
Any guidance here would be appreciated.
Thanks,
Chris
Bookmarks