Ok, i'm going to try and explain this the best I can. I am very new to Excel programming but i do have a Visual Basic programming background so I should be good to go :-) Anyway, I've got a worksheet that has various order information in it. There are numerous calculations done to determine things. If these criteria are not met, a cell is populated with the word REJECTED in it. Now there are 16 possible fields that can have this REJECTED in them. What i want to do is have those cells monitored and if REJECTED is placed into that cell, to generate an email letting the customer know why the particular order was rejected. I have the email macro figured out already but am having problems with the monitoring of those cells. Any help would be greatly appreciated.
Thanks!
Justin
Bookmarks