Excel Macros Class 5 - Get User Input - Message Box

Add to Favorites
Author: | Edits: don

Walk-through of how to use a pop-up message box in Excel to get input from a user.

This tutorial covers how to add multiple buttons to the message box, figure out which button the user clicked and change the behavior of the macro based on their action; as well, you will learn how to change some basic formatting elements of the message box and also prevent the user from clicking the red X in the corner and closing the message box window, which forces them to make a selection from the available buttons.

Question? Ask it in our Excel Forum

Downloadable Files: Excel File