Excel Visual Basic for Applications online training
Our first online training course will teach you how to write macros in Excel VBA, or Visual Basic for Applications to give it its full title. No previous programming experience is necessary!
The course contains the following 7 modules:
This module will show you how to write your first programs in VBA.
In this module you'll learn how to select cells and ranges in Excel, and how to move around a worksheet.
This module introduces two important VBA concepts: testing conditions, and doing something repeatedly (looping).
In this module you'll learn how to create variables, and how to use them to make your programs easier to understand and write.
This module shows how you can display message boxes on screen, and use input boxes to get information from users of your programs.
In this module you'll learn how to do the same thing to multiple objects (such as looping over the cells in a range, or doing the same thing to each worksheet in a workbook).
It's time in this module to learn how to intercept any errors which occur in your programs, using something called error-handling.
Click on any module to start learning!
If I had an instructor like you when I was in university, I wouldn't have become an Engineer and I became the best computer programmer.
The sequence and the logic of the VBA command that you teach make more sense why the learner needs another command to tackle the task.
Anyway, I was lucky enough to find your course and ordered your book. I hope I have an opportunity to learn more about your other courses like Power Query and Power BI. I live in the USA and I wish I had a chance to participate in your onsite classes.
Even though I have taken quite a few VBA courses by now, I learnt new things in the early stages of this course. Very high quality teaching. The downloadable files and exercises really help.