VBA Editor - Where is the watch list?

[Alex]

Hi all...

I recently purchased my Mac and Office v.X, and thus far have been very,
very happy with it - that is, until I tried to port some vba code from word xp
for windows to word x for mac...

As far as I can tell, there is no watch window in the VBA editor with Office
v.X....? Thus, there is no way for me to keep track of variables as I step
through the code...

SURELY MS could not have omitted such an essential feature? If not, is any
one aware of how to do this...?

Thanks.

 

[Bernard Rey]

I recently purchased my Mac and Office v.X, and thus far

have been very, very happy with it - that is, until I
tried to port some vba code from word xp for windows to
word x for mac...

As far as I can tell, there is no watch window in the
VBA editor with Office v.X....?

Unfortunately, you're right :-(

Thus, there is no way for me to keep track of variables
as I step through the code...
SURELY MS could not have omitted such an essential
feature? If not, is any one aware of how to do this...?

Yes, they did! And this is very, very sad in my opinion.
The kind of workaround is to use the "Immediate" window in
which you can type and execute VBA instructions. It's
certainly way back from what can be done in the Windows
version, but that's how it is.

You can also let people at Microsoft know about your
disappointment : use the corresponding item in the Help
menu in Word or any other Office app.

 

[JE McGimpsey]

I recently purchased my Mac and Office v.X, and thus far have been very,
very happy with it - that is, until I tried to port some vba code from word
xp
for windows to word x for mac...

As far as I can tell, there is no watch window in the VBA editor with Office
v.X....? Thus, there is no way for me to keep track of variables as I step
through the code...

SURELY MS could not have omitted such an essential feature? If not, is any
one aware of how to do this...?

The Mac VBE is rather limited compared to the its Windows counterpart.
No watch window, no intellisense - i.e., everything that uses ActiveX is
not implemented.

While I rarely use WinXL except for testing, I do most my development in
MacXL (my work is mostly cross-platform, so if it works on the Mac using
VBA5, it will generally work in any flavor of WinXL). To monitor
variables I sprinkle a number of Debug.Print varname statements at
critical locations in the code. If I'm stepping, I enter ?varname in the
Immediate window.