Excel VBA Basic to Advance Part2 ( 16 Hours)
In-depth study of how to deal with 100s of files insider folders, text file data handling and SuperPowerful USERFORMS
4.58 (13 reviews)
166
students
16 hours
content
Aug 2024
last update
$13.99
regular price
What you will learn
In this VBA Part2 ,We are focusing on four topics and 4 sections are there for you - File & Folder Handling ,USERFORMS,Error handlers & Workbook/Sheets Events
It has 3 sections and knowledge of arrays, loops, if statements is must before you join this course. You can check VBA Part-1, if you want to learn all this.
You shall learn how to create excel files or folders , text files, manipulate data to any extent
Taking a deep dive into library called Scripting and learning the classes of this library like fiesystemobject, file, folder and text stream
You shall be able to pick data from hundreds of excel or text files and will be able to collate it under one roof and then do whatever is required.
Creating workbooks, text files, folders, jumping inside subfolders, putting conditions, modifying the data , whatever is required, you shall be able to do it.
You shall be able to learn how to create VBA Dashboards using UserForms. Its fully basic to advance course
You shall be able to understand why it is important to know error handlers like On Error Resume Next and Go to Err.
Also, how to create message and input box with real time examples
You shall learn how to trigger vba code without running them. It is called VBA Events.
How to work with EVENTS like open event, sheet activate event, sheet change, selection change events
How to handle problems like one event calling another event when you did not even think in that way.
Use of global variables in Events - Why it is useful
Course Gallery
Loading charts...
Related Topics
4779650
udemy ID
13/07/2022
course created date
18/07/2022
course indexed date
Bot
course submited by