How to obtail a list of all Variables with values in halted proced
 

XL 2003

In dbaseIV, I was able to issue a command to list the "open" variables and
also obtain all of their values at that point.

Is there a way to do this in VBA for XL after an "F9" break point?

I do realize that I can (in the Immediate Window):

? XXXVar

Thanks Dennis

Have you looked at the Locals windows on the View menu?

--
Jim
"Dennis" wrote in message
...
| XL 2003
|
| In dbaseIV, I was able to issue a command to list the "open" variables and
| also obtain all of their values at that point.
|
| Is there a way to do this in VBA for XL after an "F9" break point?
|
| I do realize that I can (in the Immediate Window):
|
| ? XXXVar
|
| Thanks Dennis

Boy, you better believe I will from now on!

Thanks Jim

(Live & Learn)

***************************

"Jim Rech" wrote:

Have you looked at the Locals windows on the View menu?

--
Jim
"Dennis" wrote in message
...
| XL 2003
|
| In dbaseIV, I was able to issue a command to list the "open" variables and
| also obtain all of their values at that point.
|
| Is there a way to do this in VBA for XL after an "F9" break point?
|
| I do realize that I can (in the Immediate Window):
|
| ? XXXVar
|
| Thanks Dennis