Excel VBA Basic to Super Advance PART-2 (16 Hours Course)
Learn how to handle files, folders, and user forms in VBA with this comprehensive course. You’ll gain knowledge of arrays, loops, and if statements, and learn how to create and manipulate Excel files and folders. Dive into the Scripting library and explore classes like FileSystemObject, File, Folder, and TextStream. Discover how to pick data from multiple files and collate it, create VBA dashboards using UserForms, and handle errors with On Error Resume Next and Go to Err. Master VBA events like open, activate, change, and selection change events, and learn how to use global variables. This course is perfect for Excel data analysts and those looking to automate data work in Excel.
What you’ll 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
Show moreShow less
In section1, We are Learning to deal with small or large data stored in excel workbooks or text files using a library called SCRIPTING which offers us amazing classes like FileSystemObject , Folder and Files and Textstream.
How to go inside a folder and pick the needed files and then do the things like compiling data from them or modifying the files or moving them or deleting them.
Learn how to use the file-dialogs so that user can choose any folder of his or her choice and work accordingly.
Not just folders or Excel files -we are also going to see what to do if we have to overwrite or append the data in text files. Yes, we can even control the text files using scripting library, Very useful especially when you are dealing with big data.
Skip the files while running loops which you do not want. Set the filters in the extensions using file dialogs. Learn all types of file dialogs like open dialog. save as dialog, folder dialog and also why and where we can use them.
Customization of file dialog buttons, titles to how to open multiple files with them to make more user friendly and robust program which can be run in any machine irrespective of the drives or folder paths they have.
Learn to manipulate text files using scripting library. We have everything discussed here from basic level to advance level when it comes to file and folder manipulations.
In section2, we have covered all form controls like labels, textboxes, combo, listbox, frame, option buttons, check boxes and many more.
From understanding the Userform control design and properties, you shall also see the magic of userform events which are very much required to create projects.
All of your doubts will be answered via email or forum in 24 hours.
in section3, you shall learn Error handlers like On error resume next and goto err.
You shall see what are the scenarios when we already know we can have errors – VBA Errors so if we want to ignore those errors and keep continuing running the vba code, how to do that and first of all, why in first place , I will like to ignore the errors.
We will then learn how to use and customize a message box and input box in vba with various examples.
In section4, we will learn how to work with events which we write inside workbook and sheet modules.
Why they are called self triggered macros and what are the conditions – Events names we can go and use it for different type of jobs.
Learn amazing Events like – Workbook open, Sheet activate, sheet before delete, sheet change event, selection change events.
When one event starts calling another event and you never planned for it, how to avoid this class using public variable
Few projects for you to give you more confidence in Events
Who this course is for:
- Excel data analytics, Those who like to automate data work in excel.
- Those who want to create dashboards by using userforms of VBA.
User Reviews
Be the first to review “Excel VBA Basic to Super Advance PART-2 (16 Hours Course)”
You must be logged in to post a review.
There are no reviews yet.