Global Variables losing scope in Excel when developing

  • Thread starter Víctor L. Fandiño
  • Start date
V

Víctor L. Fandiño

I have a vba module inside an Excel add-in with a global variable pointing to a class in an external dll, in the form

Public MyVar as new MyLibrary.MyClass

The problem is that when I am developing and testing the add-in, the variable loses scope (not initialize). I have to close everything and restart Excel. Then all is OK.

Any suggestion?

PD. If a declare the variable without "new", where is the best place to initialize it?

Thanks in advance
 
Top