Visual Basic conceptual topics

64-Bit Visual Basic for Applications Overview

Avoiding Naming Conflicts

Calling Procedures with the Same Name

Calling Property Procedures

Calling Sub and Function Procedures

Creating Object Variables

Creating Recursive Procedures

Declaring Arrays

Declaring Constants

Declaring Variables

Executing code when setting properties

Looping Through Code

Making Faster For...Next Loops

Passing Arguments Efficiently

Returning Strings from Functions

Understanding Automation

Understanding Conditional Compilation

Understanding Named Arguments and Optional Arguments

Understanding Objects, Properties, Methods, and Events

Understanding Parameter Arrays

Understanding Scope and Visibility

Understanding the Lifetime of Variables

Understanding Variants

Understanding Visual Basic Syntax

Using Arrays

Using Constants

Using Data Types Efficiently

Using Do...Loop Statements

Using For Each...Next Statements

Using For...Next Statements

Using If...Then...Else Statements

Using Parentheses in Code

Using Select Case Statements

Using the Add-In Manager

Using With Statements

Visual Basic Naming Rules

Working Across Applications

Writing a Function Procedure

Writing a Property Procedure

Writing a Sub Procedure

Writing Assignment Statements

Writing Data to Files

Writing Declaration Statements

Writing Executable Statements

Writing Visual Basic Statements