Excel VBA Tutorial for Beginners (Part 3/10): Excel Object Model

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

Welcome to the Excel Macros/VBA tutorial for beginners. In this third video we'll talk about the Excel Object Model. We will understand which are the main Excel objects, and how to get or set the state or attributes of those objects with properties and methods. We will also learn what are events and how to use the With statement.

00:00 Excel object model
01:47 Excel VBA objects
06:16 Properties
07:43 Methods
09:31 Events
14:02 The With statement

In the next video we work with the Range object. Upcoming 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:
Рекомендации по теме
Комментарии
Автор

I'm tring to wrap my head around on how vba works for months now, you playlist are super useful to get the core on how vba works, thanks dude.

TheZenytram
Автор

Fine, useful videos, thank you for sharing

janezklun