Where to put "global" VBA globals?

J

Jens Lenge

Where shall I declare truly "global" Excel VBA variables/constants that are
to be accessed from all modules?
 
J

Jens Lenge

Where shall I declare truly "global" Excel VBA variables/constants that
are to be accessed from all modules?
Click to expand...

Just found out myself:
Declare them in any module, but declare them as "Public".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Global Template Network and saving auto texts & macros 2
Comparing Constants between Active Project and Global File 0
Where to put global variables? 2
global variable 3
Cannot find path! 2
Can excel objects be defined as global variables 2
Weird Behaviour of Compiler Directives? 14
Get Contact from a Global Address list? 0

Top