I thought they were global

[Everso]

I have a sub that defines a new collection. I then attempt to add an item to it within a function and it craps out complaining about the object not being defined. I thought that once an object was defined it was accessable to everything.

Any ideas what's wrong?

Everso

[gdebacker]

It depends upon how you define it. The only way to make a variable (object or otherwise) avaialble to everything in your program is to use the Public key word in a module.

'In a module
 
'Available to everything
Public MyCollection As Collection
 
'Available to everything in this module
'But not other forms or modules
Private MyCollection As Collection

{EDIT} It must be defined in the declarations section of the module. Defining it in a sub or function in a mdoule does not work.

Greg

[gdebacker]

You can create an object in a sub and then pass a reference to a function in another module without the object being public.

Greg

[Everso]

Thanks. I'll go have a play. I was hoping to avoid a module because it allways seems silly having a module with only a declaration in it

Everso