The Variable List Form
The Variable List form is used with the Debug Display to display variable values as you step through a program. The Variable List Form is displayed by clicking on the 'Variables' button, the right-most button in the top row, on the Debug Display.

Here's an example of the Variable List displayed for the program "HelloWorld".

The Variable Form displays the variable names local to the active worksheet and the Global variable names for the active workbook. The form is used while stepping through a program using the Debug form, it is not active while running a program outside Debug. It provides a convenient way to look at the variables as they are changing, especially while debugging a long program where the variables on the worksheet are out of view.

You can use the 'Refresh' button on the form to refresh all the variable values to the current state.

The variable list uses the Excel Name list to display the variables. If you see a variable name in the list that doesn't belong or is no longer used, you can delete it using the Excel menu item 'Insert -> Name -> Define', then select the name and delete it.

 Live Excel Help!

Free initial talk time, no charge until you're convinced that the expert can help you!

Expert Excel Help!
Powered by LivePerson