برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Excel: Macros and VBA for Beginners

47mBeginner2025-01-07

Authors

Oz du Soleil

Excel MVP, Author, and Trainer

Course details

If you’re a frequent user of Excel, chances are you have Excel tasks that you need to repeat often. Fortunately, you can automate these tasks by creating macros. Many people assume macros are complicated and reserved only for Excel power users. Not so! In this short course, Excel MVP Oz du Soleil explains the best times to use a macro and how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. Learn how to set up macros in Excel now so you can save time later.

Skills covered

SpreadsheetsMicrosoft ExcelProgramming LanguagesBusiness Software and ToolsMicrosoftSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Macros and VBA for beginners

1. The World of Macros and VBA

02 - Making the case - Why a macro and not regular Excel
03 - A word about AI and LLMs

2. Record a Basic Macro

04 - Add the Developer tab to your ribbon
05 - Record the macro and review the code
06 - Stepping through the code

3. Other Things to Know Before Creating Macros

07 - Warnings about VBA and macros - There is no undo
08 - Warnings about VBA and macros - Recorded macros are literal
09 - Warnings about VBA and macros - Errors
10 - The VBA environment
11 - Four ways to launch macros

Conclusion

12 - You can do anything with VBA - Real-world examples
13 - A look at where to go next