<div>
You can't do what you want. You have to create a property that accesses the array. And you have to define the array as private to the class.<br />
<br />
Kevin
</div>


You can't do what you want. You have to create a property that accesses the array. And you have to define the array as private to the class.

Kevin

<div>
 Excuse my ignorance but how do I do that ? I'm not sure what you mean.<br />
Toco
</div>


Excuse my ignorance but how do I do that ? I'm not sure what you mean.
Toco

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am trying to declare a public variable array in Excel VBA as follows :<br />
<br />
Public Qty(10) As String<br />
<br />
.....but when I reference the array in my Sub it returns the following error :<br />
<br />
&quot;Constants, fixed length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules&quot;<br />
<br />
I'm able to reference other variables as Public but not the array. The variables are held in a Class Module called c_Invoice (I'm not sure how this differs from other Modules).<br />
<br />
Any ideas<br />
Regards<br />
Toco
</div>
</div>


Hi,
I am trying to declare a public variable array in Excel VBA as follows :

Public Qty(10) As String

.....but when I reference the array in my Sub it returns the following error :

"Constants, fixed length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules"

I'm able to reference other variables as Public but not the array. The variables are held in a Class Module called c_Invoice (I'm not sure how this differs from other Modules).

Any ideas
Regards
Toco

How do I declare a public array variable in Excel VBA ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.