Locals window for debugging VB code?

[Peter]

Is there any way to see the intermediate values of
variables as you step through a VB macro? I know on the PC
version the debugger includes a "Locals" window which shows
the state and values of every variable in use. Is there
anything like this for the Mac version?

If not, and if someone at Microsoft is listening, PLEASE
create one in future versions of the VB Editor for the Mac.
It's torture trying to debug without it.

Any VB gurus have suggestions on how to monitor varible
values while stepping through a macro?

Thanks in advance!

-Peter

 

[JE McGimpsey]

Any VB gurus have suggestions on how to monitor varible
values while stepping through a macro?

Use the immediate window, or put Debug.Print statements inline.

 

[JE McGimpsey]

If not, and if someone at Microsoft is listening, PLEASE
create one in future versions of the VB Editor for the Mac.
It's torture trying to debug without it.

Saying it here is less likely to be effective that using the
Help/Feedback on Excel menu item.

Having said that, however, it's unlikely that the VBE will be updated.
VBA is dying, to be replaced by something else, either in Office 12 or
13. I don't see the investment being made.

However, that doesn't mean that whatever replaced VBA won't have a
better IDE.