Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,113
- Office Version
- 365
- Platform
- Windows
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,
Please let me know, because I cannot figure it out!
Greatly appreciate it!
Thanks!
-Pinaceous
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,
VBA Code:
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