I have 3 subroutines Check, Submit and Filter. Check and Submit both call on Filter to Filter on a given spreadsheet. I want to have an If Statement in the Filter Macro that allows me to forego a MsgBox if the Macro detects the data is clean if Submit is run, but want to execute the MsgBox if Check is run. Is there some VBA language that will do that or should I designate a range on a spreadsheet to 0 and 1 it based on the Macro that called?
Bookmarks