I've got one here I can't figure out! What I'm trying to do is look at a cell and if when it changes it falls within a certain range I trigger a message box or an email. I know how to create a message box or an email using VBA but the trick is finding an event that I can use to evaluate the cell that I'm looking at. This sheet is linked to a live data source using a plug-in so cells are constantling being updated. I can write a loop that continues to look at the cell but that incapacitates the sheet. How can I evaluate this cell (or range of cells)??? There doesn't seem to be a "on cell change event." Any ideas??