Declaring a public array

[eargo]

Hiya, how do you declare a public array? exactly? I can find no code snippets - and when I try:
public dim colorarray(1 To 15) As Long

I get an error. I've tried it inside a public function, and inside the calling cmd_button - and outside - still no joy. Basically, I want to be able to access the array from 1 Sub and 3 functions.

Thanks

Yum.

 

[RobBroekhuis]

Leave the "dim" out. "public" implies you're dimensioning.
Rob

 

[eargo]

what exactly do I put, and where, I'm just getting errors when I declare it outside the subs or modules, and errors if I declare it inside.

 

[RobBroekhuis]

Be sure to put the declaration at the top of your module, before any subs or functions. If you still get errors, please tell us which ones.
Rob