| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping track of Global variables
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. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping track of Global variables
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? 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping track of Global variables
They appeared in the locals window for me.
-- Regards, Tom Ogilvy "Stuart" wrote in message ... 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. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Keeping track of Global variables
Many thanks.
Regards. "Jan Karel Pieterse" wrote in message ... 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? 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Global Variables in a module | Excel Programming | |||
| Global variables cleared by forms? | Excel Programming | |||
| Global Variables using User Forms | Excel Programming | |||
| Global Variables Not Accessible | Excel Programming | |||
| Declaring Global Variables | Excel Programming | |||
![Stuart[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
