MICROSOFT VISUAL BASICS (EXCEL)

Visual Basic is programming in Excel. Although the course is different from the run-of-the-mill formulas, advanced Excel knowledge is required. On the first day, you will become familiar with the various functions, while on the second day you will take part in ‘practicals’ where you apply the newly gained knowledge to different scenarios and become confident in practical use.

• Unit 1: VBA coding- where to start
  1. Developer toolbar
  2. Understanding coding for macros

• Unit 2: Basic functions
  1. Referencing to sheets
  2. Referencing to ranges
  3. Declaring a variable

• Unit 3: User forms
  1. Inserting a basic user form
  2. Opening and closing user forms
  3. Labels, text boxes and lists
  4. Checkboxes, option boxes and toggle boxes

• Unit 4: Formulas
  1. IF formulas
  2. Nested IF formulas
  3. Other formulas

• Unit 5: Loops
  1. Loops
  2. Using different modules for different macros
     and naming them
  3. WITH statements

• Unit 6: Finishing your program
  1. . Testing and debugging
  2. Protecting your code

• Unit 7: Other codes
  1. Protecting sheets and unprotecting sheets
     with coding
  2. Message boxes
  3. Hiding and unhiding sheets, rows and
     columns with coding
  4. Inserting, deleting and renaming sheets
  5. Cleaning cells
  6. Running a code when opening a workbook
  7. Using the personal macro workbook to save
     different codes and how to add codes to the
     customised ribbon

• Unit 8: More complicated programs explained
  1. Building a navigational sheet with buttons
     and userforms
  2. Creating a userform which updates a
     database every time you change the
     database

• Unit 9: Free codes to use
  1. Opening multiple files and importing data
  2. Unhiding all sheeting in a file
  3. Listing all the sheet names in specific files