VBAFuncRecord Structure

Introduction

VBAFuncRecord is a binary structure used to represent a single method within a VBA module. It describes various aspects of the function or sub, such as its name, visibility, return type, and argument list.

Structure Description

Version-dependent fields

These field are present for all version, but with different position. A and B represent version-dependent offset for these fields, with following values:

Flag1 bits

Flag2 bits

The Flag2 field is a byte that contains flags related to the type of method being parsed.

HasUserMemFlag bits

The HasUserMemId indicates whether the UserMemId field for a given function or sub has been set.

In VBA, a developer can add a unique identifier to a function or sub using the Attribute statement, like this:

Attribute MyID.VB_UserMemId = 1

More details about UserMemId here.

SpecialFlag bits

The SpecialFlag variable is a single byte where each bit indicates whether the function or sub has certain attributes.

• Bit 5 (counting from the least significant bit) is used to indicate whether the function or sub has a return value.
• Bit 7-6 are used to indicate whether the function or sub is an API declaration statement.

NewProcFlags bits

The NewProcFlags variable is a single byte where each bit indicates whether the function or sub has certain attributes.

• Bit 1 is used to indicate whether the function or sub is private.
• Bit 2 is used to indicate whether the function or sub is a friend function (VBA term for a function that is accessible from other modules within the same project).
• Bit 6 is used to indicate whether the function or sub has been marked as “PtrSafe”, which is a feature introduced in VBA 7.0 to help ensure that calls to external libraries are safe in a 64-bit environment.