Excel VBA Tutorial for Beginners (Part 1/10): Introduction

preview_player
Показать описание

Welcome to the Excel Macros/VBA tutorial for beginners. This first video is just an introduction, where we'll see the benefits and potential of Excel VBA, along with some macro examples, and we'll add the developer tab and explore the visual basic editor (see timeline below).

00:00 Intro
00:16 What is an Excel VBA macro
01:00 Simple Excel macro examples
06:06 More advanced Excel macros/VBA projects
09:02 The Excel developer tab
09:52 The Visual Basic editor
14:04 Save macros

In the next video we'll see what modules and procedures are, and we will create our first macro. Follow-up videos will cover the contents as per below.

Contents:
1. Introduction
2. Modules and Procedures
3. Excel Object Model
4. The Range Object
5. Variables
6. Conditions and Loops
7. Arrays
8. Messages and Input
9. Userforms
10. Debugging and Error Handling

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Рекомендации по теме
Комментарии
Автор

Great stuff you are doing in Excel. Thanks for the video man :)

thomasw.