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.

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *