When I run a script I get an error message saying there in no data. Which is what I am expecting... but is there a way to make it so instead of seeing that message which will confuse non-tech people to no end for some reason.

Is there a way to change that through VBA or a setting somewhere that can be attached to the workbook so when that message comes up instead of saying error ##: no data, it will say something like "The data you are attempting to import has already been imported, there is no new data, please update the XXXX Tab and run this script again."?

Thanks.