Visual Basic for Applications

Conventions

• Code Guide
• FAQ

Concepts

• Modules
• Classes
• Events
• Interfaces
• Convention over Configuration

Code

• Developer Tool Bar
• Array functions
• HTML
• XML
• Data Abstraction Layer
• Status

Problems and solutions

Double code execution

Problem

The function provided with the OnAction property is executed twice.

Solution

Put the function name in single quotes:

.OnAction="'functionname'"

Corrupt Microsoft Access database

Problem

Microsoft Access gives strange errors, when trying to compile the project.

Solution

Decompile your database

Tricks

• If you need to use keywords in an enumeration, for example, you can escape the keyword check with square brackets:

Public Enum Keyword
    [Boolean] = 1
    [Integer] = 2
    [String] = 3
End Enum