How to Master the VBA Message Box in 6 Minutes
ฝัง
- เผยแพร่เมื่อ 15 พ.ย. 2022
- 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
SUBSCRIBE TO THE CHANNEL: bit.ly/36hpTCY
DOWNLOAD 20+ Message Box Examples: bit.ly/3hNCVlN
Related Training
The Excel VBA Handbook Course(TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(excelmacromastery.com/excel-v...)
Free Excel VBA Resources
Excel VBA Articles (excelmacromastery.com/vba-art...)
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) - วิทยาศาสตร์และเทคโนโลยี
DOWNLOAD 20+ Message Box Examples from here: bit.ly/3hNCVlN
Thanks Paul, We need a video every Week.
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!
Awesome 👏 Have been using VBA from couple of year now but this content is amazing
Glad you like it
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.
Aaah.. if I knew earlier that I can learn this in 6 mins... Thaaaaaaaaanks ❤
You are a master mind in vba amigo!! I wish i had the same skill as yours!!
Thanks Rene
Great! Thanks Paul!!
Thanks Wayne
Clear and awesome!
Thanks, Master.
Glad you like it Mariano
great video, thanks.
Very usefull info. Thx!
You're welcome
LOVE IT
Полезное видео для новичков.
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"?
Thanks
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.
Nice Explained.
Thanks for liking
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
✔️ ρяσмσѕм