How to stop Locals window from constantly collapsing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Garth Robbins - 11 Feb 2005 20:44 GMT

Could anyone who uses the Locals window to track their variables please let
me know how to keep the lines in the window (each starting with the + sign)
from collapsing and hiding my variables everytime VBA jumps to a different
part of my code? I'm guessing it happens because I have multiple procedures
and they collapse every time you return to a different sub.

Thanks,
Garth

Reply to this Message

Perry - 06 Mar 2005 19:55 GMT

The variables go out of scope. They're not in memory/they're dead.

The only thing you can do is to broaden the scope of your variables.
Declare them with a public scope
Once the code executes wihout bugs and yr satisfied, you can go back
to declare the variables within the routines where they belong,
so as to save yourself precious resources.

Krgrds,
Perry

> Could anyone who uses the Locals window to track their variables please let
> me know how to keep the lines in the window (each starting with the + sign)
[quoted text clipped - 4 lines]
> Thanks,
> Garth

Reply to this Message