Excel Macro Mastery
Welcome to my Excel VBA Channel. My name is Paul Kelly(Microsoft MVP) and I'm here to teach you how to write Excel VBA for the real world.
This channel will teach you proven techniques and little-known secrets about Excel VBA. These are techniques and secrets that I have used myself for over 20 years as a professional software developer.
In these videos, I break down complex Excel VBA topics in simple terms. I explain each part with code examples. Then I show you how to put it all together with real-world coding examples.
You can check out free articles on my Excel VBA website: excelmacromastery.com/vba-articles/
Become an Excel VBA Mastery:
☛ The Excel VBA Handbook course: courses.excelmacromastery.com/courses/excel-vba-ha…
☛ Effective Excel VBA: courses.excelmacromastery.com/courses/Effective_Ex…
☛ The Webinars Archives Membership: excelmacromastery.com/live-webinars/
Excel Macro Mastery
Which video would you watch?
2 months ago | [YT] | 11
View 11 replies
Excel Macro Mastery
Which of the following skills would you most like to master? (If your preference is not included then add in comments)
5 months ago | [YT] | 16
View 6 replies
Excel Macro Mastery
My latest video covers Python for VBA developers(https://youtu.be/-2yM9KkegOQ?si=DHBfz.... Which language do you use most often?
1 year ago | [YT] | 16
View 3 replies
Excel Macro Mastery
Why are you learning VBA?
1 year ago | [YT] | 12
View 1 reply
Excel Macro Mastery
Which video should I make next?
1 year ago | [YT] | 21
View 21 replies
Excel Macro Mastery
Working on my latest video - a modern style UserForm ListBox for VBA with sort, filter and hover highlight and fully configurable headers
1 year ago (edited) | [YT] | 163
View 14 replies
Excel Macro Mastery
🚨 Flash Sale Alert! 🚨
Get 25% off my "Effective Excel VBA" course until midnight Pacific Time!
Finally Master Excel VBA in Excel. Even if all your previous attempts have failed, your time
is limited and VBA looks like a foreign language to you.
Don't miss out on this limited-time offer!
Here are the highlights:
*A systemized approach: Gone are the days of staring blankly at your screen, wondering where to start. My systemized approach breaks down the writing code into clear, manageable steps, ensuring you never feel lost again.
*Proven Best Practices: Enhance your code with principles that have been proven to work over and over in the real-world.
*Pre-written code snippets: There is no need to reinvent the wheel. Take my optimized code and use it in your own application with little or no modifications.
*Practical Learning: Each module has related exercises so that you can learn by doing. Doing proper exercises is the fastest way to improve your VBA skills.
Enroll now and save: courses.excelmacromastery.com/courses/Effective_Ex…
#ExcelVBA #FlashSale #LearnVBA #ExcelAutomation
1 year ago (edited) | [YT] | 18
View 0 replies
Excel Macro Mastery
Where do you use Excel VBA?
1 year ago | [YT] | 32
View 17 replies
Excel Macro Mastery
HOW TO CREATE A USERFORM LIKE A PRO
https://youtu.be/qcQ5EivyrXs?si
DOWNLOAD THE CODE
shorturl.at/yBSVX
Creating UserForms in VBA should not be that complicated. However, there are lots of pitfalls for the unwary. For example
1. How do you retrieve a value after the userForm closes?
2. How do you avoid automation errors if the error cancels using X?
3. How do you stop a modeless UserForm from disappearing?
4. How do you pass the initial settings to the UserForm before the initialize event runs?
and so on.
In this video, I show how to create Modal and Modeless UserForms like Pro while overcoming all issues that may arise.
#ExcelVBA #VBAUserForm #UserForm #ModalUserForm #ModelessUserForm
1 year ago (edited) | [YT] | 20
View 0 replies
Excel Macro Mastery
If you could have someone happen instantly and it cost $2000 which would you pick?
2 years ago | [YT] | 13
View 12 replies
Load more