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!

Comments are closed.