How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

1 year ago
27

May 1, 2018 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/

You'll quickly learn the right syntax you'll need to create a VBA message box (or a pop up dialogue box) in Excel. I first show you how to create a simple message, and then we expand on this to include "YES" & "NO" buttons.

More details:
In the video, I'll also show you how to add a line break to your message box using Vbnewline and also how to use a variable which you can use to assign the answer of the message box to. You'll need this if you have "YES", "NO" or "CANCEL" buttons, so you know which one the user has clicked on.

★ Download the VBA file: https://www.xelplus.com/vba-message-box/

★★ Links to related videos: ★★
Copy/Paste in Excel VBA: https://rumble.com/v2u2oh6
Referencing Ranges with VBA: https://rumble.com/v2u2ofm
Learn about Visual Basic Editor: https://rumble.com/v2tv4va
Recording macros: https://rumble.com/v2tv4ui
Properties & methods in VBA: https://rumble.com/v2tv4wg

★ My Online Excel Courses ★

Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#ExcelVBA

Loading comments...