Declaring a variable that is known across modules

Officer_Bierschnitt · #1 11-18-2015, 12:34 AM

Quote:

Originally Posted by shg

You don't need a separate module, but it's a good idea. Just declaring them as Public is sufficient to make them visible throughout the project.

You just can't have another variable more local in scope with the same name.

I'll try. One project can encompass several modules, can't it? I was getting some error_messages in the 2nd module yesterday which led me to believe that my variables - already declared as PUBLIC in the 1st module - were not recognized there. Might have been something different, I'm still not very advanced.

Thanks a lot!

Best regards,

DataNibbler

P.S.: How would I have to do this with a separate module? I haven't found a specific How-to for this. Does there have to be a Sub() in there with the CALL-command for the next module?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Modelling training modules	Vincent	Project	3	09-03-2014 05:37 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Empty Modules	Greg S.	Excel Programming	2	07-30-2013 01:38 PM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM