Main Page

This site is all about Visual Basic and Visual Basic for Applications.

Conventions

• Naming Conventions
• Coding Conventions
• FAQ

VBA

Conventions

• Code Guide
• FAQ

Concepts

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

Code

• Developer Tool Bar
• Array functions
• 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'"