VBA Text Message If statement

[Pinaceous]

Hi All,

I want to create an If statement IF Column E has an interior-colored red cell with the text "ABC123" and Column F is occupied that a text message appears.

For example,

Private Sub MessageColumnE(ByVal Target As Range)

If Column E has an interior-colored red cell with the text "ABC123" AND Column F is NOT Empty then

Message Box "MY POP-UP"

End If

End Sub

Please let me know, because I cannot figure it out!

Greatly appreciate it!

Thanks!
-Pinaceous

 

[Alex Blakenburg]

You really need to give more context in the question. Most of the details you need for this are in your previous post in Zot's response.
VBA Red Cell Criteria

If Range("E" & n).Interior.ColorIndex = 3 _
    And Range("E" & n) = "ABC123" _
    And Range("F" & n) <> "" Then
    
        MsgBox "MY POP-UP"
End If

 

[Pinaceous]

 Dim n As Range

?

 

[Alex Blakenburg]

I am assuming the context relates to your previous thread.
I hope @Zot, doesn't mind me screenshotting this.

 

[Pinaceous]

I am assuming the context relates to your previous thread.
I hope @Zot, doesn't mind me screenshotting this.

View attachment 73141

Hi Alex Blakenburg,

Thanks for clarifying and yes it does relate to what I'm trying to accomplish.

Thanks so much!
pinaceous

 

[Alex Blakenburg]

You’re welcome. Glad I could help.