Here's my class module:
== Original Class Module ==
Option Explicit
Private m_parts(4) As String
When I compile it, I get this error:
"Compile error:
Constants, fixed-lengths, arrays, user-defined types and Declare statements not allowed as Public members of object modules"
When I go to the Excel help, I get this:
"You declared a Public array in an object module.
Although a procedure can't return an array, it can return a Variant that contains an array. To simulate a Public array in a class module, use a set of Property procedures that accept and return a Variant containing an array."
The question is,
How do I accomplish this? I'm not that familiar with the Variant or get / let / set commands. I need to be able to use arrays my program.
Start Free Trial
