Checking the values of public variables in Excel VBA - Locals Window Alternative

Question

I have been using the Locals window to check the assignments for procedure level variables.

I have recently updated my code to create a set of public-level variables that read certain inputs from the sheets which do not change from project to project.

When seeking to check these variables, I do not see them in the Locals window, no doubt because they are not locally-defined variables!

Is there an alternative to the Locals Window for Public variables? And if not, how am I supposed to check public variable assignments?

Answer 1

In addition to the Immediate window (as described in the other answer), the Watch window is very helpful in those circumstances. You can activate it in the View menu -> Watch window:

Here you can define:

• Any variable (e.g. your public variables)
• A full term, e.g. ActiveWorkbook.UsedRange.Address
• The scope of each watch
• Even a breakpoint when the value changes or results in True - this is quite handy when debugging, as it allows you quick conditional breakpoints without adding additional code, e.g. if you set a watch to myVar=0 and active Break When Value Is True, the code will automatically stop the moment the potential bug is "initiated"

You can add all of these options in the "Add watch" dialog, which you either get by right clicking on any variable (or other code) in the code module - or by right clicking in the watch window:

In addition, you can simply edit any watch items in the list by double clicking.

Very handy tool for debugging, esp. in combination with Locals and Immediate windows.