color defined globally vba
Posted on 2012-03-20
How do I set global variable in my Excel vba project and how can I call it from any module,sheet,form or class.
Is Gobalscope a term associated with setting these variables. Can I define an entire function globally? Please post an example if possible.
The project is to store or call colors defined in the vba proj (chart creation)that can be defined globally in a page so I dont have to change them on each page individually and can alter them in one location itself.