Video Lesson: Introduction to Macros & VBA

Using macros in Excel requires knowledge of Visual Basic for Applications (VBA).  In this video lesson you will get an introduction to how macros work within Excel and how to build them.  The video lesson includes the following topics:

– Setting up Excel workbooks to use Macros & VBA (filetype, menu and security settings).

– How to record a macro and edit recorded VBA code.

– How to write custom macro including InputBox and MsgBox functions.

– How to assign buttons and shortcuts to macros.

Make sure to download the Visual Basic Examples workbook here to follow along.

This entry was posted in Data Input & Manipulation, VBA / Macros and tagged , , , , , , . Bookmark the permalink.

28 Responses to Video Lesson: Introduction to Macros & VBA

  1. sunny says:

    No idea

  2. Demon Pornski says:

    I am doing quite well – Thanks Excel!

  3. Michael says:

    April 16th be my b-day! Yay!

  4. mohammad hasib says:

    Very good for new learner
    thank you so much

  5. Anonymous says:

    how to download this video

  6. Joanne says:

    I’m just starting to learn macro & VBA and this site is so helpful. Thanks a lot!

  7. Anonymous says:

    These videos are very helpful, but unfortunately your spreadsheets do not start at the same starting point that your videos start. The VBA examples spreadsheet already has the macros built instead of giving us a blank slate to follow along with your video and create the macros.

  8. ask says:

    It’s impressive that you are getting ideas from this piece of writing as well as from our dialogue made here.

  9. Anonymous says:

    So helpful! Thanks so much for the tutorials!

  10. emran says:

    hey dude!! very much thanks to you for sharing your videos. i made me to learn excel in my free time. may god bless you.. amen!!

  11. Anonymous says:

    Spectacular tutorial, Thanks Ben!

  12. Hari says:

    Hello Sir

    Your Videos are very helpful to me. thanks a lot…

    Please tell me whats the VBA code to run the “input box” macro every time we open a work book.

    can we give a password for the workbook in the sameway using VBA code?

    thanks in adv.

  13. Rex says:

    How are you doing ben?

  14. Alphaxard says:

    Hi Ben, I don”t quite understand what the macros and VBA are used for, but you”re an awesome teacher!

    • Hey Alphaxard,

      Glad you enjoyed the lesson! Macros are primarily useful in automating actions in Excel so that they do not have to be performed manually. For example, you could have a Macro that goes through the first 10,000 cells and delete any cells that contain a particular letter, which would take much longer manually.

      I’d recommend checking out the lessons on the Purchase Order Generator and Message Encoder/Decoder for examples of how they can be used.

      Hope that helps clear it up a bit.

      Cheers,

      Ben

  15. Anonymous says:

    Dear Ben,

    I just wanted to say thank you very much for all of your time and effort that went into making these excellent tutorials. I was recently made redundant and have used your videos to improve my skills and therefore my marketability.

    • So glad that the site was able to help you improve your marketability. Very sorry for your job loss, I know it can feel difficult at times, but good on you for doing something about it and trying to improve your skills!

      Cheers,

      Ben

  16. Anonymous says:

    Dear Ben,

    I just wanted to say thank you very much for all of your time and effort that went into making these excellent tutorials. I was recently made redundant and have used your videos to improve my skills and therefore my marketability.

    Thank you very much from London, UK!

    Warmest regards,

    Jennifer

    • Hey Jennifer,

      I’m so happy to hear that the site has been able to help you so much. I’m sure you’re right about it increasing your marketability in terms of a new job.

      It’s amazing how important it is to have someone with deep Excel knowledge on the team.

      Keep up the good work!

      Cheers,

      Ben

  17. Thanks, Ben! As someone who’s hard-coded user-driven analysis tools in other environments, I really appreciate you covering InputBox. Looking forward to the next VBA tutorials!

  18. Pingback: A Complete Introduction to Excel | MBAx.me

  19. Anonymous says:

    Ben,

    Thank You very much for posting this free tutorials, very helpfull.

  20. Brian says:

    Excellent introduction

  21. Anonymous says:

    yes it is excellent

  22. Jebzaki says:

    I just found this through Reddit and I’m quite grateful. A clear and concise first lesson.

Comments are closed.