Microsoft Visual Basic for Excel

Lethabo Chauke

I was able to understand everything taught in this course. I will definitely recommend eLearning.co.za to all my colleagues.

Roliswa Mdluli

I loved learning about coding. Course well laid out and presented.

What are the prerequisites?

• Computer/Laptop
• Microsoft VBA (for practicals)
• Email for notifications and communications
• Internet connection
• PDF viewer (e.g ADOBE Acrobat)
• A web browser

What other related courses are offered?

We provide a variety of courses, from computer studies to leadership and softskills courses.

The following are our most popular courses:

This course was not easy but very interesting. I learned so much. Thank you for explaining everything so well.

Course Content

Job Market Prospects

Microsoft Visual Basics is a huge advantage to have at many companies. 

​

​

​

​

What other people are saying:

How long does it take to complete?

How much does it cost?

Unit 1 - VBA coding- where to start

1.1 Developer toolbar

1.2 Understanding coding for macros

Unit 2 - Basic Functions

2.1 Referencing to sheets

2.2 Referencing to ranges

2.3 Declaring a variable

Unit 3 - User Forms

3.1 Inserting a basic user form

3.2 Opening up and closing user forms

3.3 Labels, text boxes and lists

3.4 Checkboxes, option boxes and toggle boxes

Unit 5 - Loops

5.1 Loops

5.2 Using different modules for different macros and naming them

5.3 WITH statements

Unit 7 - Other codes

7.1 Protecting sheets and unprotecting sheet with coding

7.2 Message boxes

7.3 Hiding and  unhiding sheet, rows and columns with coding

7.4 Inserting, deleting and renaming sheets

7.5 Clean cells

7.6 Running a code when opening a workbook

7.7 Using the personal macro workbook to save different codes and how to add codes to the customised ribbon

Unit 4 - Formulas

4.1 If formulas

4.2 Nested IF formulas

4.3 Other formulas

It takes between 4 days and 2 weeks, depending on your speed.

R 150 (incl VAT) for access to The Accelerator Programme 

for a year  

Or

Microsoft Excel Basic

Microsoft Excel Intermediate

Microsoft Access

Microsoft Word Beginner

Microsoft Excel Advanced

Financial Modeling

Daniel Arendse

Unit 6 - Finishing your program

6.1 Testing and debugging

6.2 Protecting your code

Unit 8 - More complicated programs explained

8.1 Building a navigational sheet with buttons and userforms

8.2 Create a userform which updates a database every time you change the database

Unit 9 - Free codes to use

9.1 Opening multiple files and importing data

9.3 Unhiding all sheets in a file

9.4 Listing all the sheet names in a specific file