Visual Basics Course

INTRODUCTION

This course will teach you visual basics to enable you improve your programming skills

DURATION OF THIS VISUAL BASICS COURSE

2 full days.

WHO SHOULD ATTEND THIS COURSE?

Accountants, Creditors Clerks, Debtors Clerks, Administration clerks, Financial Managers, Engineers, Students. MBA graduates.

COURSE DATES

We do not have workshops currently, but only provide on site training customized to your needs.

PRICING

The cost for on-site training is R10,000 per day. Maximum 15 delegates for computer training and 30 delegates for soft skills training.

You can also do the course online for $50. Our elearning platform is one of the best in the world and includes videos, simulations, assessments, examples and examinitions. You can print your own certificate on completion of the examination.. Contact us for a free demo.

OUTLINE

Unit 1: VBA coding: Where to start

Topic A: Development toolbar

Topic B: Understanding coding for macros

Topic C: Defining ranges

Unit 2: Basic functions

Topic A: Referencing to sheets

Topic B: Referencing to ranges

Unit 3: User forms

Topic A: Inserting a basic user form

Topic B: Opening up and closing user forms

Topic C: Labels, text boxes and lists

Topic D: Checkboxes, option boxes and toggle boxes

Topic E: Inserting coding in user forms

Topic F: Ensuring users follow your program

Unit 4: Formulas

Topic A: If formulas

Topic B: Nested IF formulas

Topic C: Other formulas

Unit 5: Loops

Topic A: Declaring a variable

Topic B: Loops

Unit 6: Finishing your program

Topic A: Testing and debugging

Topic B: Protecting your code

Unit 7: Other codes

Topic A: Protecting sheets and unprotecting sheet with coding

Topic B: Message boxes

Topic C: Hiding and un-hiding sheet with coding

Topic D: Inserting, deleting and renaming sheets

Topic E: Clean cells

Topic F: Running a code when opening a workbook

Unit 8: More complicated programs explained

Topic A: Building a navigational sheet with buttons and userforms

Topic B: Create a userform which updates a database every time you change

Topic C: Change information in textboxes with selections from list boxes

Topic D: Debugging with message boxes

Topic E: Creating new excel files and saving the files on new folders in the

Folders.

Unit 9: Free codes to use

Topic A: Opening folders and saving the result

Topic B: Opening multiple files and unknown names

Topic C: Un-hiding all sheets in a file

Topic D: Listing all the sheet names in a specific file

 

 

Empower Yourself - BOOK NOW!

Visual Basics Course

Address:

Unit 11, Block 2
Falcon Crest Office Park
142 South Street
Die Hoewes
Centurion
South Africa

Contact Details:



*


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela