Happy to report that I found a decent workaround to the "msgBox" problem I reported earlier. Basically, just take out the MsgBox from your function code and let the user select parameters as they want. On clicking "View Report", your validation function will turn ON or OFF the boolean parameter and it will dictate whether your entire report shows up or a customized error message shows up.

I my proof of concept, I made all parts of the function parameterized so that even the message can be customized. I will post it here later.

Prasanna, your example here and the word document helped a lot. Thanks a lot for your contribution.