Excel VBA Tutorial for Beginners (Part 1/10): Introduction
3 هزار بار بازدید -
3 سال پیش
-
Get the Excel VBA Guide
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. 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
You can read more and find 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/)
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
You can read more and find 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/)
3 سال پیش
در تاریخ 1400/09/28 منتشر شده
است.
3,045
بـار بازدید شده