How can I make a dialogue box pop up with a notice to user?

[Guest]

I need to have a dialogue box come up with a note to the user when certain
conditions apply. I know how to create a macro that will run when the
conditions apply, I just don't know how to create the dialogue box that will
appear. Thanks in advance.

 

[Norman Jones]

Hi Carl,

'=============>>
Public Sub Tester()

MsgBox Prompt:="Your message", _
Buttons:=vbInformation, _
Title:="MESSAGE"
End Sub
'<<=============

 

[Guest]

Thanks! Worked perfectly!

Hi Carl,

'=============>>
Public Sub Tester()

MsgBox Prompt:="Your message", _
Buttons:=vbInformation, _
Title:="MESSAGE"
End Sub
'<<=============