For individual or corporate-training and software-development needs, you may contact us.

Advanced VBA Course Content

VBA DAY 1
  • Introduction to VBA, code window
  • Introduction to datatypes
  • Basic string functions
Download Video
Or Watch on Youtube
Assignment
(coming soon)
Assessment
VBA DAY 2
  • Variant Data type
  • Implicit datatype conversion
  • Compiler directive 'Option Explicit'
  • Function procedure
  • Difference betwee Function and Sub Procedure
Download Video
Or Watch on Youtube
Assignment
(coming soon)
Login to try Assesment
VBA DAY 3
  • Ways of calling a function
  • Optional Parameters
  • ByVal & ByRef
  • If statement : Single-line & multi-line
  • Option Compare Text
  • Recursive Functions
Download Video
Or Watch on Youtube
Assignment
(coming soon)
Login to try Assesment
VBA DAY 4
  • For Loop
  • Immediate Window
  • Nested For Loop
  • Introduction to Excel Object Hierarchy
  • For-each Loop
  • Do-While, While-Wend and Do-Until Loop
  • Comparison between For and other Loops
Download Video
Or Watch on Youtube
Assignment
(coming soon)
VBA DAY 5
  • Select case statement
  • Introduction to inbuilt objects
  • Method and Properties
  • Object Browser revisited
  • More on immediate window: Use of '?'
  • Making IntelliSense work with range
  • Watch window
Must enrol
VBA DAY 6
  • ActiveSheet, ActiveCell, Selection
  • Pattern example using cells property
  • Introduction to offset propert
  • Pattern example using offset property
Must enrol
VBA DAY 7
  • Usefulness of Macro Recording
  • Clear, ClearContent, ClearFormat properties
  • Font, Color, Alignment properties
  • Sorting, Filtering range
Must enrol
VBA DAY 8
  • CurrentRegion Property
  • UsedRange property
  • EntireRow, EntireColumn, Insert, Delete
Must enrol
VBA DAY 9
  • InputBox function
  • Problems with variables
  • Introduction to single-dimentional array
  • Static and Dynamic declaration of array
  • Option Base 1 compiler directive
Must enrol
VBA DAY 10
  • Split function
  • Example of split function
  • Introducton UDF
  • Using split example as UDF
Must enrol
VBA DAY 11
  • Introduction to multi dimentional array
  • Resizing a dynamic multidimentional array
  • Range To array and Array to Range
Must enrol
VBA DAY 12
  • Workbook and worksheet properties
  • Copying, Deleting, Inserting sheet
  • Opening, closing and modifying a workbook
Must enrol
VBA DAY 13
  • Introduction to FSO
  • Looping through files using FSO
  • Consolidating data
Must enrol
VBA DAY 14
  • Introduction to Dictionary
  • Unique feature of dictionary
  • Example
Must enrol
VBA DAY 15
  • Introduction to sheet controls
  • Checkbox Option Button and use of GroupBox
  • Listbox and Dropdown
Must enrol
VBA DAY 16
  • More Listbox Examples - Transfer data between listbox; Hide unhide sheets
Must enrol
VBA DAY 17
  • Introduction to userform
  • Modal and Non modal
  • Textbox, Label, Command button, Listbox, Combobox
Must enrol
VBA DAY 18
  • Form Events
  • Form design technique
  • Listbox example using form
Must enrol
VBA DAY 19
  • Worksheets and Workbook Events
  • EnableEvents property
  • DoEvents
  • ScreenUpdating and DisplayAlert property
Must enrol
VBA DAY 20
  • File dialog: Open, SaveAs
  • Introduction to Windows API
Must enrol
VBA DAY 21
  • Database connectivity
  • Connection Object
  • Recordset object
  • Fetching and updating data
  • Executing query
Must enrol
VBA DAY 22
  • Recordset type: Static, Dynamic, Keyset and Forward-only
  • CopyFromRecordset property of range
  • Fetching Headers from Database using recordset
  • Creating a data uploader
Must enrol
VBA DAY 23
  • Access specifier
  • Static variables
  • Constants
  • Enum
  • Type
Must enrol
VBA DAY 24
  • Introduction to user-defined Class
Must enrol
VBA DAY 25
  • Error Handling
  • Why do we need Exception Object
  • Resetting Exception Object
  • Resetting Error Handler
  • On Error Resume Next
Must enrol
VBA DAY 26
  • The infamous Y2K problem
  • Working with Dates
  • Late and Early Binding
  • Internationalization of application
Must enrol
VBA DAY 27
  • Introduction to Chart
  • Changing chart properties
  • Switching Axis
  • Creating a bubble chart
Must enrol
VBA DAY 28
  • Example of dashboard
  • Dashboard creation consideration
Must enrol
VBA DAY 29
  • Addin Creation
  • Registering adding
  • Programming the ribbon
Must enrol
VBA DAY 30
  • Best Practices of programming
  • Connecting Excel with Powerpoint
Must enrol
StandardVBA.com©   All rights reserved     Facebook Twitter