How to Master the VBA Message Box in 6 Minutes
Vložit
- čas přidán 15. 11. 2022
- 👉 Ready to master VBA?
- Check out my full courses: courses.excelmacromastery.com/
- Subscribe to the channel here: bit.ly/36hpTCY
-Want to download the source code for this video? Go here: bit.ly/3hNCVlN
(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) - Věda a technologie
DOWNLOAD 20+ Message Box Examples from here: bit.ly/3hNCVlN
Crisp with clarity at its best , thanks a lot Master
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!
Thanks Paul, We need a video every Week.
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.
Awesome 👏 Have been using VBA from couple of year now but this content is amazing
Glad you like it
Aaah.. if I knew earlier that I can learn this in 6 mins... Thaaaaaaaaanks ❤
Clear and awesome!
Thanks, Master.
Glad you like it Mariano
Great! Thanks Paul!!
Thanks Wayne
great video, thanks.
Полезное видео для новичков.
LOVE IT
You are a master mind in vba amigo!! I wish i had the same skill as yours!!
Thanks Rene
Thanks
Very usefull info. Thx!
You're welcome
Superb explained. Thank you very much.
Thanks Michael.
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"?
Nice Explained.
Thanks for liking
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.
hi , how can i disable or remove the msg box ?
1:05 Sooooo... 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?
You may have an error in your code. Use debug and compile to find and remove all errors. It should work fine then.
@@Excelmacromastery I get no errors, and when I click compile, it executes without any warnings. *shrug*
need vba code for automatic popup & disappear after few seconds
You'll need to use a timer and userform
✔️ ρяσмσѕм