Ok I have been searching for awhile doing a project for work. I am trying to create a macro that will display a message box when a value of B13 through AW13 is greater than 3.5. So if B13 is calculated higher than 3.5 I need a message to pop up saying Resample and later on if I get a value in J13 it to pop up saying the samething. I currently have it so it will pop up however, if B13 is higher than 3.5 then every time I enter more data the message continues popping up I only want it to pop up once per time it sees over 3.5 in those cells. I will attach my excel so you can see what I am referring to.Untitled.png
Bookmarks