Excel Macros & VBA: 2 Write your first Macro in Excel VBA using the VBA Editor

// FREE Excel E-book "Record Your First Macro"

// Recommended Excel Courses //

// Recommended Excel Templates //

If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.

They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!

——
// EPISODE NOTES

In today's video I will:

▸ Show how to write a new one-line macro in Excel 2016 (and run it) in less than 2 minutes

▸ Explain how to step line-by-line through your macros in the VBA Editor (use the keyboard shortcut F8)

▸You will learn how easy it is to start writing Macros to automate Microsoft Excel.

——
// LEARN MACROS WITH LAUNCH EXCEL

Most Excel users never start using Macros because they either haven't heard of them, or feel overwhelmed because they think it's all too hard. This is a shame because Macros and VBA can give you Excel superpowers.

You can save vast amounts of time by automating repetitive tasks and even create your own new functionality to do things that Excel does not do by itself.

But... it sometimes looks like Excel Macros are so technical. Don't worry, in this video I will talk you through step-by-step how to write your very first Macro.

——
// VISIT MY WEBSITE

[launchexcel]

Thanks for watching this video about writing your first macro in the VBA Editor. You can get your free e-book at the following link:

Please do leave comments below with any questions you have about learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!

[Myskyisblu]

Thank you so much! Feeling so mind blown that I haven't exploited all these features despite using excel on a daily basis. Your videos are awesome and super helpful :)

[limfun]

thanks for sharing very clear and useful tips on excel. I am checking for the methods to read pdf file into excel for data validation purpose.

[lewisshaw]

Hi victor,

Thanks for doing these videos, they are great and informative.
Really appreciate your hard work.

[gopalakrishnarao]

Thanks for uploading a video, This is very helpful.

[launchexcel]

I reveal a simple yet powerful way to learn more about the VBA language. It's built into Excel and you can start using it right now.

[jcguevara]

What is the point of these button though?

[launchexcel]

Hi all - I just got an interesting comment from a viewer that didn't get published by YouTube, and I'd like to publish it myself to respond because I think it will help other viewers.

Here's the comment that didn't get published... ""what the hell ? So all the VBA can do is greeting ur or displaying some message ? how it is related to macros ? what the purpose ? where can it be useful, in what jobs I might use it for work ? Sorry, I know u put effort in this but Im gonna delete also the e-book. Its just useless."

The best thing to do is read my article "how to do 10 hours work in 10 seconds" because it explains how to use VBA and Macros to reduce the time it takes for repetitive jobs.

In my latest article I explain four areas in which you can use VBA and Macros:

1. Bridging the gap between IT project implementations
2. Create unified solutions between Office and Database tools
3. Quickly create custom applications
4. Automate and speed up repetitive tasks


There's definitely more you can do than just display some messages... but this YouTube video is for beginners to start off with small bite-sized tutorials.


Cheers,
- Victor

P.S. Do feel free to ask more questions - I'm here to help!