Hi, I'm having trouble getting my workbook to run code properly.
I have a Userform that imports a range of data (using "Add details" and "Save and Close" buttons) into a worksheet called Monitor. Within this Monitor, this imported data is compared with another sheet and if any cells have changed, identified in column A, it automatically sends out an email using a subroutine located in ThisWorkbook. The email part works fine if I manually change the data in Monitor, but it doesn't send an email when the data is imported.
I've tried getting it to run this subroutine from the "Save and Close" in the Userform but with no luck.
This is the email code in ThisWorkbook:
Please Login or Register to view this content.
And this is what I have in Monitor:
Please Login or Register to view this content.
Bookmarks