Originally published: 07/09/2018 07:36
Last version published: 08/12/2019 08:07
Publication number: ELQ-32561-6
View all versions & Certificate

An Introduction to VBA Course

This course will help you understand the fundamentals of VBA so you can program all by yourself.

Excel automation is an vital skill set for users who want to take their knowledge to the level where they can make bespoke applications. You will create a variety of VBA macros learning how to best automate repetitive tasks, create customised forms and programme solutions in Excel.

Having completed this course you should be able to:

Know the Excel VBA object model
Create procedures from scratch in VBA
Generate and use variables
Referencing ranges worksheets and objects (the right way)
Write flexible VBA code to manipulate datasets in any way
Using the locals window to monitor your procedures
Use a range of common VBA programming techniques
Generate event change procedures that run automatically

The course starts with the basics and builds understanding gradually from recording macros to customising the code to create your own bespoke procedures. There is a great many tips and tricks to simplify your coding so it is efficient and effective as possible.

This Excel training course is suitable for those who work on Excel and who want to become familiar with and master Visual Basic for Applications. This course will give you the foundations and structure in your coding journey to become a weapons grade master with practice and time.

This Best Practice includes
4 Videos (5 Hours) + 4 Supporting Excel Files

Acquire business license for $150.00

Add to cart

Add to bookmarks



  • Be the first to review this Online Course

    Write a review


More Best Practices from Marcus Small

See all

Any questions on An Introduction To VBA Course?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...