How to use Message Box in Excel?

A MsgBox is nothing but a dialog box that you can use to inform your users by showing a custom message or get some basic inputs (such as Yes/No or OK/Cancel). While the MsgBox dialog box is displayed, your VBA code is halted. You need to click any of the buttons in the MsgBox to run the remaining VBA code.

Hover your cursor over Insert and select Module from the menu that appears.

  1. This will create a new blank module.
  2. This is where we begin typing our MsgBox function.
  3. Now we can run the macro by clicking the Run Sub button (green “play” button) or pressing F5.