Скачать или смотреть Excel VBA Tutorial for Beginners (Part 2/10): Modules and Procedures

Get the Excel VBA Guide for Beginners with extended and revised content here: https://excelmacroclass.blogspot.com/...

Welcome to the Excel Macros/VBA tutorial for beginners. In this second video we'll see what modules and procedures are, and create our first macro. We will also learn how to call procedures and run macros (see timeline below).

00:00 Intro
00:50 Modules
02:53 Procedures
04:48 Function procedures
08:17 Event procedures
10:58 Public vs private procedures
12:38 How to call a procedure/run a macro

In the next video we will talk about the Excel Object Model. 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

Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the link: https://excelmacroclass.blogspot.com/

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:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)