VBC09354: Invalid qualifier
Severity: Error · Family: VBC (static semantics / abstract syntax tree) ·
Source metadata: VBCompileErrorInfo
A member is accessed on a value that has no members.
A number, a String, a Boolean or a Date is a value, with no members, and so is an array, fixed-size or resizable: only an object, a user-defined type, a module or an enumeration has members to access with a dot. A Variant compiles, whatever it holds: one that holds an array or a number when the member is read, assigned or called is run-time error 424, Object required.
MS-VBA reports the same error, with the same message (recorded in Excel).
This code is raised by MemberAccessExpressionStaticSemantics.
How it is raised
| Situation | Example | Resolution |
|---|---|---|
A member of a Long. |
Dim n As Long … Debug.Print n.Value |
Remove the member, or declare the variable as the class that has it. |
| A member of an array, read or assigned. | Dim v(2) As Long … v.Foo = 1, Dim v() As Long … x = v.Foo |
Index the array first, v(0), when its elements are objects or records; to count its elements, use UBound(v) - LBound(v) + 1. |
See also
ACCUEIL • HOME | ℹ️ BIENVENUE • WELCOME | 🧩 BÂTISSONS • BUILD | RD-VBAL | SDK | 🌐 rubberduckvba.ca