Microsoft Office Development and Consultancy

VBA

 -

Getting Started

 -

Coding Standards

 -

Indentation and Whitespace

 -

One Instructon Per Line

 -

Line Continuation Character

 -

Comments

 -

Operators

 -

Constants

 -

Enumerations

 -

If - Then - Else

 -

For - Next

 -

Do - Loop

 -

While - Loop

 -

Select Case - End Select

 -

With - End With

 -

Colours

 -

Keywords

Syntax categories

 -

Array - Creating, initialising, populating and using arrays.

 -

Conversion - Converting between datatypes and numbers.

 -

Dates & Times - Entering, calculating and manipulating dates and times.

 -

Files & Directories - Controlling the file system and processing files.

 -

Financial - Financial calculations, interest rates, annuity, depreciation.

 -

Input & Output - Receiving input and displaying or printing the output.

 -

Maths - Common functions and trigonometric equations.

 -

Objects - Loads, removes and identifies objects.

 -

Registry - Read, write and remove entries from the registry.

 -

Strings & Characters - Manipulating text strings and changing the case.

 -

Other - Everything else, formatting, pictures, colours, events.

Advanced

 -

Functions Added in 2000

 -

GoTo Statements

 -

Switch

 -

Choose

 -

Application.Match

 -

Immediate IF (IIF)

 -

Custom Lists

 -

Advanced Techniques

 -

Knowledge Base

 -

Knowledge Base - Numerical

 -

Code Snippets

Shortcut Keys

(Ctrl + Space) - Displays the drop-down list of auto-list intellisense

Related Topics

 -

Procedures & Functions

 -

Variables