Keeping track of Global variables

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

If I declare a Global variable, then I believe I'm
correct in saying that it will not be displayed in the
Locals window.

If so, then when debugging, how best to keep track
of its' value, please?

Regards.
 
Hi Stuart,
If I declare a Global variable, then I believe I'm
correct in saying that it will not be displayed in the
Locals window.

If so, then when debugging, how best to keep track
of its' value, please?
Click to expand...

You can expand the tree of the entire project by clicking the plus sign
to the left of it (in the locals window), so it shows you all of the
projects objects and global variables. Or you can of course add a watch
to a few variables by rightclicking them and selecting add watch.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Many thanks.

Regards.

Jan Karel Pieterse said:
Hi Stuart,


You can expand the tree of the entire project by clicking the plus sign
to the left of it (in the locals window), so it shows you all of the
projects objects and global variables. Or you can of course add a watch
to a few variables by rightclicking them and selecting add watch.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
Click to expand...
 
You must log in or register to reply here.

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

Keeping Variables Alive 13
global variables 4
How to display value of global variable? 5
using Global variable of Userform in module 2
One Variable Available In Three Workbooks 2
Can excel objects be defined as global variables 2
Enumerate all global variables? 1
unwanted reinitialization of global variables 10

Back
Top