VB Question - Message Box

[lfeikema]

HELP PLEASE. I don't think like a programmer, hence my question. I have an excel spreadsheet and I need to add a pop message based on the value of cell (for multiple cells). I know this is easy for most. I'd appreciate all the help I can get.

 

[Logit]

.

Option Explicit


Sub mymsgbox()
    If Range("A1").Value = "Yes" Or Range("A1").Value = "yes" Then
        MsgBox "This is your msgbox.", vbInformation, "Hey"
    End If
End Sub

 

[LFKim2018]

HELP PLEASE. I don't think like a programmer, hence my question. I have an excel spreadsheet and I need to add a pop message based on the value of cell (for multiple cells). I know this is easy for most. I'd appreciate all the help I can get.

May I suggest:
People here will have a better solution for you if you explain better what you need.
when, where and how do you want to pop a message etc.. in detail if possible.
a clearer view enhances a panorama..
thank you

 

[Michael M]

OR ALSO....

Option Compare Text
Sub mymsgbox()
    If Range("A1").Value = "Yes" Then MsgBox "This is your msgbox.", vbInformation, "Hey"
End Sub