Excel Macros Class 5 - Get User Input - Message Box
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
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.)
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)