Full Table of Contents for Excel VBA Courses

Published September 11, 2022 · Updated September 12, 2022

I'm uploading a separate table of contents for the entire Excel VBA lecture I've been writing. I put a link in the entire table of contents so that you can find this article as an index.

Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) (prodskill.com)

<<Table of Contents>>

Toggle

1. Excel VBA Overview

• 1.1. VBA, Macro concept
• 1.2. Experience, knowledge, and mindset required to approach Excel VBA
• 1.3. What can you do with Excel VBA?
• 1.4. A step-by-step approach to learning Excel VBA
• 1.5. Factors that make Excel VBA difficult and how to solve it
• 1.6. Do's and Don'ts of using Excel VBA
  • 1.6.1. When using Excel VBA
  • 1.6.1. When not to use Excel VBA

2. Excel VBA Basics

• 2.1. Basic Preferences
• 2.2. Follow simple example
  • 2.2.1. “Hello, World!” output
  • 2.2.2. Entering values into cells
  • 2.2.3. New file
• 2.3. Excel Object Model
  • 2.3.1. Application
  • 2.3.2. Workbooks
  • 2.3.3. Workbook
  • 2.3.4. Worksheets
  • 2.3.5. Worksheet
  • 2.3.6. Range
• 2.4. Understanding the Excel Object Model with simple code
  • 2.4.1. object access primitives
  • 2.4.2. simple object access
  • 2.4.3. Object Access & Utilization Examples
• 2.5. Excel Object Model Details
• 2.6. Excel File Extension
• 2.7. Visual Basic for Application Editor (VBE)
  • 2.7.1. Execute with shortcut to switch VBE
  • 2.7.2. Toggle VBE Execute with ribbon bar button
  • 2.7.3. VBE settings
  • 2.7.4. VBE Screen Composition
  • 2.7.5. Recommended monospaced fonts that are easy to read

3. Excel VBA language basics

• 3.1. variable
  • 3.1.1. variable declaration
  • 3.1.2. Variables Early binding, Late binding
• 3.2. Language Syntax
  • 3.2.1. conditional statement (IF)
    • Single line IF syntax
    • Single line IF sample code
    • Multiple line IF syntax
    • Multiple line IF sample code
  • 3.2.2. Condition function (IIF)
    • IIF grammar
    • IIF sample code
  • 3.2.3. Conditional statement (Select Case)
    • Select Case Conditional Syntax
    • Select Case conditional sample code
  • 3.2.4. Repeat statement (For)
    • For Next Loop Syntax
    • For Next loop sample code
  • 3.2.5. Loop (For Each)
    • For Each Loop Syntax
    • For Each loop sample code
  • 3.2.6. loop (While)
    • while loop syntax
    • While loop sample code
  • 3.2.7. Loop control (Exit, Continue)
    • How to use If block
    • How to use Goto
  • 3.2.8. Procedure
    • Sub procedure syntax
    • Sub procedure sample code
    • Function procedure syntax
    • Function procedure sample code
  • 3.2.9. error handling
  • 3.2.10. Visual Basic (VB) Documentation Help (CHM)
  • 3.2.11. Office 2013 VBA Documentation (CHM, English)
• 3.3. data type
  • 3.3.1. basic data type
    • List of basic data types
    • Variant data type
    • User-defined data type
  • 3.3.2. data structure
    • Array
    • Collection
    • Dictionary

4. Excel VBA How-To

• 4.1. How to configure UI (User Interface)
  • 4.1.1. UI using Excel Sheet
  • 4.1.2. UI using User Form
  • 4.1.2. UI using Ribbon Bar
• 4.2. How to run VBA code
  • 4.2.1. Fire on button click event
  • 4.2.2. Place the cursor on the source code to be executed and execute it with a shortcut key
  • 4.2.3. Run in the Immediate Window
• 4.3. How to use the Immediate Window tool
• 4.4. How to use the object browse tool
• 4.5. How to improve VBA performance
• 4.6. How to use the macro recorder
• 4.7. Basic principles to follow when coding

5. Tools developed with Excel VBA

• 5.1. Naver Korean Dictionary, English Dictionary Search Tool
• 5.2. Work allocation optimization tool using one-dimensional bin packing algorithm
• 5.3. Data standard check tool
• 5.4. DA# Macro Tool
• 5.5. PowerDesigner Macro tool
• 5.6. Data Migration (Migration) Tools
• 5.7. Excel Data Downloader
• 5.8. Excel Data Uploader

Related articles:

Excel VBA Course (10): Tools developed and used with Excel VBA Excel VBA Courses (9): Excel VBA How-To Excel VBA Course (8): Excel VBA Language Basics - Data Types, Data Structures Excel VBA Course (7): Excel VBA Language Basics - Syntax Excel VBA Course (3): Excel Object Model Excel VBA Course (2): Excel VBA Basics Excel VBA Course(1): Overview of Excel VBA Start the Excel VBA course. (Lecture notice, feat. Why we recommend Excel VBA)