Validate active cell and prevent mail from firing.

[kmakjop]

Hello, i am trying to get some assistance with the code below. In active cell row "S", each time the value changes, it should trigger an email and color the row a specific color, that part works okay. However, to prevent it from firing when it shouldn't, I want to validate it by using the cell color as a check, if the cell color is green, it means the mail was already sent for example, so it shouldnt send it again if selected.

In the code here, it should be, if the active cell row "S" colorindex = 4, then dont fire the mail again. I have been trying but each time i get close to solving it, it messes up something else in the code, kindly help please.

Please Login or Register  to view this content.

[kmakjop]

any help here please?

[kmakjop]

Any suggestions please?

[Richard Buttrey]

Sounds like you need an initial IF test

If Cells(ActiveCell.Row, "S").Font.ColorIndex <> 4 Then
....rest of your code
End If

[kmakjop]

Thank you for responding Richard, i didnt saw that you did. I actually came up with something like what you suggested, see below and tell me if what i have so far will be okay. I am actually checking for five different values, below is one of the five checks, the coding for all five are the same, just the and msgbox contents and the mail type that is called is different.

Please Login or Register  to view this content.