How to Master the VBA Message Box in 6 Minutes

preview_player
Показать описание
👉 Ready to master VBA?
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

How to Master the VBA Message Box in 6 Minutes

The VBA Message Box is a very powerful tool. But most users are unaware that it is highly configurable. In this video, you will learn how to master the message in just 6 minutes. You will be able to easily set buttons, icons, highlight a button with a few simple parameters. You will also and easily detect which button the user clicked.

#VBAMsgBox #VBAMessageBox #ExcelVBAMessageBox

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)
Рекомендации по теме
Комментарии
Автор

clear, concise, showed results of different code, gives enough context for me to go get my ideas into VBA without needing it spelled out for me. Perfect!

andrewbouc
Автор

Crisp with clarity at its best, thanks a lot Master

Darshanam-Jatra
Автор

This is good information.

I prefer to use Select/Case instead of ElseIf. It's a lot cleaner and easier to manage, in my opinion. But what you presented is spot on, so I'm not kickin' ya in the knees.

hotflashfoto
Автор

Awesome 👏 Have been using VBA from couple of year now but this content is amazing

mshanabar
Автор

Thanks Paul, We need a video every Week.

hammeedabdo.
Автор

Aaah.. if I knew earlier that I can learn this in 6 mins... ❤

fekrabusinesssolutions
Автор

You are a master mind in vba amigo!! I wish i had the same skill as yours!!

reng
Автор

Clear and awesome!

Thanks, Master.

m_marcamo
Автор

Superb explained. Thank you very much.

MikePDE
Автор

Question, I've got a scenario I'm wondering if it is doable with Message Boxes. Is it possible to have a message box pop up as an event procedure say maybe upon opening a workbook and display only cells that have values in a given range as well as values of an adjacent column? So for example, if I want a message box to show only those cells that have values from Column I(Eye not L) and then the corresponding values in column C, could a message box do that as a vertical listing? So something like:

John Smith - 100
Nancy Smith - 50
Paul Smith - 75

I'm not familiar with the limitations of Message Boxes, but is it possible to do something like that?

bhar
Автор

Thanks for the video, so just to confir, the option vbDefaultbutton 1 ...n can be use to declare a custom button displayed in the message box? for example I have a button from a message box coming up from an application, the options are "Run" and "Cancel". Defaltubutton 1 would be "Run"?

leviatan
Автор

Hello Paul, your videos have helped me tremendously. I have been having issues connecting to a PDF software that our company uses. Even though Kofax PowerPDF has a guide for VBA automation stuff online, I cannot seem to make it work. Do you have any video or website recommendations for connecting to applications? Their Technical Support team has been no help, and any attempts to make connections like the examples they show in the guide are not working. I figured a bright mind like yours might be able to point me in a good direction to figure this out.

DimebagDerekS
Автор

hi, how can i disable or remove the msg box ?

mohammedhashim
Автор

need vba code for automatic popup & disappear after few seconds

krishnamanjunatha
Автор

1:05 The intellisense (or whatever it's called) bar you're referencing there, it never appears for me, meaning I always have to guess or else look up this stuff online, no idea how it got turned off, or how to turn it back on. Anybody know?

Nevir