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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Hi Carl,

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

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

Norman Jones said:
Hi Carl,

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

MsgBox Prompt:="Your message", _
Buttons:=vbInformation, _
Title:="MESSAGE"
End Sub
'<<=============
Click to expand...
 
Back
Top