• • Introduction
  • Accessing VBA Editor
  • Debugging
  • Option Explicit
  • VBA Excel Macros

• • Modules
  • Procedure

• • Apostrophe Comments
  • REM Comments

• • Syntax for MsgBox
  • MsgBox Button Constant
  • MsgBox Icon Constants
  • MsgBox Return Value

• • Syntax for InputBox

• • Numeric Data Types
  • Non-Numeric Data Types

• • Syntax for Constants

• • Mathematical / Arithmetic Operators
  • String Operators
  • String Operators
  • Logical Operators

• • IF…Then Statement
  • IF…Then…Else Statement
  • IF…Then…Elseif…Else Statement
  • Select….Case Statement | Switch Statement

• • For … Next
  • For Each… Next
  • Do…While Loop
  • Do…Until Loop
  • While…Wend

• • InStr Function
  • InstrRev Function
  • LCase Function
  • UCase Function
  • Left Function
  • Right Function
  • Mid Function
  • Len Function
  • Trim Function
  • LTrim Function
  • RTrim Function
  • Space Function
  • Replace Function
  • StrComp Function
  • String Function
  • StrReverse Function

• • Date Function
  • CDate Function
  • DateAdd Function
  • DateDiff Function
  • DatePart Function
  • DateSerial Function
  • FormatDateTime Function
  • IsDate
  • Day Function
  • Month Function
  • Year Function
  • MonthName Function
  • WeekDay Function
  • WeekDayName Function
  • Now Function
  • Hour Function
  • Minute Function
  • Time Function
  • TimeSerial Function

• • Declaring an Array
  • Assigning values to an Array
  • Multi-Dimensional Arrays
  • ReDim Statement – Dynamic Arrays
  • Array Functions
  • Split Function
  • Join Function
  • UBound Function
  • LBound Function
  • ISArray Function
  • Filter Function
  • Erase Function

• • Workbook Events
  • Worksheet Events

• • Syntax Error
  • Compile Error
  • Runtime Error
  • Error Handling
  • On Error Goto 0
  • On Error Resume Next
  • On Error Goto <label>

• • Objects
  • Properties
  • Methods
  • Application Objects
  • Workbooks Objects
  • Worksheet Objects
  • Range Objects

• • UserForm
  • Controls

Project for practical knowledge