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.

17 thoughts on “Video Lesson: Introduction to Macros & VBA

  1. 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.

    • 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

  2. 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

  3. 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

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

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s