Difference between revisions of "Visual Basic for Applications"

From vb24
Jump to navigation Jump to search
(Created page with "== General ==")
 
Line 1: Line 1:
 
== General ==
 
== General ==
 +
 +
== Conventions ==
 +
* [[VBA Code Guide|Code Guide]]
 +
* [[VBA FAQ|FAQ]]
 +
 +
== Concepts ==
 +
* [[VBA Module|Modules]]
 +
* [[VBA Class|Classes]]
 +
* [[VBA Event|Events]]
 +
* [[VBA Interface|Interfaces]]
 +
* [[VBA Convention over Configuration|Convention over Configuration]]
 +
 +
== Code ==
 +
* [[Developer Tool Bar]]
 +
* [[Array functions]]
 +
* [[VBA HTML|HTML]]
 +
* [[VBA XML|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:
 +
<syntaxhighlight lang="vb">
 +
.OnAction="'functionname'"
 +
</syntaxhighlight>

Revision as of 14:54, 7 February 2015

General

Conventions

Concepts

Code

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'"