This is an example of extending VBA by creating a new function.
Problem: You want to pop up a MsgBox to the user but also send an email to yourself that something went wrong. Another way to do this would be to log the error to a file and then have an Excel/VBA process to monitor the file.
|