This online course is to understand the advanced VBA Macros training. This course will help you understand how to create a user form and its features such as the combo box, list box, radio button, check box, looping and referencing. Next we would see the recording of macros, modifying code and linking to the user, sorting numbers, creating graphs, printing and emailing reports.
7h 58m | 67 Videos | 29326 Views | Expert
Online VBA Macros – Advanced Course Training
This is part II of our program. These video tutorials provide an advanced overview of using Excel VBA Here we will work on case study approach, and coding aspects of the form.
You must be knowing that a UserForm is a custom-built dialog box which is builtusing the Visual Basic Editor. It acts as a simple interface for entering data. You must have seen it hundreds of times, but we are here to teach you how to create one! So in this module you will learn about Userform Combo Box, Userform List Box, Userform Radio Button and Userform Checkbox.
Use of Update Now
In this module you are going to learn some important VBA macros functions like Looping for Next, Nested Loops, Do until Loops, Do While Loops, Referencing Sheets and much more.
Writing formulas and EMI Calculations
Then comes an important milestone in you program where you will understand ‘Writing Formulas’ in detail. It forms an important part of your learning and we also provide you with the practice test for the same. In EMI calculation part of the case study, the video tutorials on PMT formulas, recording macros, debugging the code etc take you to a further level of learning VBA.
In this module you are here to learn about sort EMI button, array basic, Sorting Numbers using Arrays, Sorting Strings using Arrays and Sort Bank Details with respect to the case study provided.
Here you will understand the simple ways and tricks of creating graphs.
Get ready to learn the PRINT function in VBA Macros through this module.
Here you will understand in detail the functions of creating PDF and email report.
Where do our learners come from?
Professionals from around the world have benefited from eduCBA’s Visual Basic for Excel – Advanced courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many.