What is Microsoft Visual Basic about?

Visual Basics is programming in Excel. Although the course is different from the run of the mill formulas, advanced Excel knowledge is required for this course. On the first day, the learner becomes familiar with the various functions and on day two he conducts ‘practicals’; where he applies his newly gained knowledge in different scenarios and becomes confident in his usage.

Lethabo Chauke

I was able to understand everything taught in this course. I will definitely recommend onedollarcourses.com 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.

only $1 + 36c

(The 36c is the administration fee)


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

Microsoft Visual Basic

Microsoft Visual Basic