• Introduction
• Code Explorer
• Tools & Builders
• MS Access tools
• Add Procedure
• Variables
• Working with objects
• Control structures
• Dialogs
• Getting names
• Custom classes
• Customize

Introduction

• Starting to use Code VBA
• Tools overview
• IntelliSense
• F1: Tooltips and help

Code Explorer

• Code navigation
• Insert procedure call
• Rename procedure
• Delete procedure
• Immediate Window
• Tidy code
• Comment out code
• Handling errors
• Add line numbers

Tools & Builders

• Procedurecall Builder
• UserForm Builder
• Class Builder
• Procedure Builder
• Loop Builder
• If/Select Builder
• Condition Builder
• MsgBox Builder
• InputBox Builder
• SelectionBox Builder
• Datepicker Builder
• Variable Builder
• Constant Builder
• Enum Builder
• String Builder
• Folder Builder
• Quick Menu

MS Access tools

• Recordset Builder
• Class from Table
• SQL VBA Builder

Add Procedure

• ... Quickly
• Procedure Builder
• Macro Creator
• Record a Macro
• Manage macros
• Procedure Arguments
• Property Builder

Variables

• Available Variables
• Declare Quickly
• Procedure arguments
• Variable Builder
• Naming conventions
• Constant Builder

Working with objects

• Introduction
• Object menus
• Excel Application
• Access Application

Control structures

• If Then Else
• Select Case
• Condition Builder
• Do While
• For i=.. To
• For Each
• GoTo and GoSub

Dialogs

• MsgBox
• InputBox
• SelectionBox
• DatePicker
• UserForm Builder
• Application dialogs

Getting names

• Current Module
• Current Procedure
• Labels
• File or Folder
• Form or Control
• Excel sheet
• Excel range
• Current Document

Custom classes

• Using the Class Builder
• Property Builder
• Property Quickly
• Class from Access table
• Using Collections

Customize

• Code VBA toolbar
• Tooltip on MouseHover
• Code insertion
• Snippets library