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.
I was able to understand everything taught in this course. I will definitely recommend onedollarcourses.com to all my colleagues.
I loved learning about coding. Course well laid out and presented.
- 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.
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.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 Word Beginner
Microsoft Excel Advanced
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