Excel VBA: Using Message Boxes – MsgBox

Displaying messages when you are running any program, and a macro is a type of program, is a useful way to display information or to get interaction from end users.

You might want a simple message box to inform the user that some data has been imported and the macro is complete. Another option is to use a message box with a yes or no option asking if you would like to print the spreadsheet or not when it has finished doing all the reorganising and formatting of data.

Here in this video you will a start with using message boxes.