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.