Microsfot Excel - Macro - How to display popup message in message box

Watch this example on YouTube

Sub Test()
   MsgBox "This is my message"
End Sub