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.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)