Excel VBA Macros Tutorial in just 1 Hour
Вставка
- Опубліковано 24 лип 2024
- Get the Excel VBA Guide for Beginners with extended and revised content here: excelmacroclass.blogspot.com/...
This is a special edition of the Excel VBA/Macros tutorial for beginners in just 1 hour. We will cover the basics of Excel VBA programming and learn to create simple macros. The tutorial covers the following topics - see timeline below:
00:00 Intro
00:28 Developer Tab and Visual Basic Editor
04:32 Modules and Procedures
10:20 Excel Object Model
16:03 The Range Object
22:00 Variables
28:22 Conditions and Loops
36:13 Arrays
43:13 Message and Input Boxes
50:50 Userforms
56:15 Error Handling and Debugging
58:46 What next?
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)
thank you you've saved me
Awesome video!
Excelent profesor. I use excel dayly in my job.
Thank you!