[SOLVED] How to find Watch window in Office X VB Editor (Mac OS X)

Greetings all,

Apologies if this is a FAQ here but I've searched google for over an
hour with no result. I've just updated to a new machine, running Mac OS
X (Tiger) and installed Office X (after updates, 10.1.6). I
have dozens of legacy Excel files with all manner of VB code in them
from my Excel 5 under Mac OS 8.6 and I'm trying to make them work under
this new system environment.

One major problem is that I can't figure out how to get out a Watch
window!!! I've looked until I'm blue in the face and there is nothing
in any menu which will bring out a window where I can see variable
values at runtime. I can get out the Immediate window, but that doesn't
help and in any case I'm not interested in typing in the same variable
multiple times!

The help system is useless (not that I'm surprised). My web searches
turn up documents which tell me to click Add Watch from the View menu
(AFAIR), which doesn't exist.

Please, is there someone out there who's solved this problem on Office X?
--
N Sanders, in New Zealand, DownUnder
Please reply to the group, thanks.

news://msnews.microsoft.com/microsof...c.office.excel
may get you the best response.

--
Regards,
Tom Ogilvy



"N Sanders" <nospam@myplace.nz> wrote in message
news:nospam-144817.20573210112005@lust.ihug.co.nz...
> Greetings all,
>
> Apologies if this is a FAQ here but I've searched google for over an
> hour with no result. I've just updated to a new machine, running Mac OS
> X (Tiger) and installed Office X (after updates, 10.1.6). I
> have dozens of legacy Excel files with all manner of VB code in them
> from my Excel 5 under Mac OS 8.6 and I'm trying to make them work under
> this new system environment.
>
> One major problem is that I can't figure out how to get out a Watch
> window!!! I've looked until I'm blue in the face and there is nothing
> in any menu which will bring out a window where I can see variable
> values at runtime. I can get out the Immediate window, but that doesn't
> help and in any case I'm not interested in typing in the same variable
> multiple times!
>
> The help system is useless (not that I'm surprised). My web searches
> turn up documents which tell me to click Add Watch from the View menu
> (AFAIR), which doesn't exist.
>
> Please, is there someone out there who's solved this problem on Office X?
> --
> N Sanders, in New Zealand, DownUnder
> Please reply to the group, thanks.

Thanks for the tip :-)


In article <e5uBJFf5FHA.620@TK2MSFTNGP12.phx.gbl>,
"Tom Ogilvy" <twogilvy@msn.com> wrote:

>news://msnews.microsoft.com/microsof...c.office.excel
>may get you the best response.
>
>--
>Regards,
>Tom Ogilvy
>
>
>
>"N Sanders" <nospam@myplace.nz> wrote in message
>news:nospam-144817.20573210112005@lust.ihug.co.nz...
>> Greetings all,
>>
>> Apologies if this is a FAQ here but I've searched google for over an
>> hour with no result. I've just updated to a new machine, running Mac OS
>> X (Tiger) and installed Office X (after updates, 10.1.6). I
>> have dozens of legacy Excel files with all manner of VB code in them
>> from my Excel 5 under Mac OS 8.6 and I'm trying to make them work under
>> this new system environment.
>>
>> One major problem is that I can't figure out how to get out a Watch
>> window!!! I've looked until I'm blue in the face and there is nothing
>> in any menu which will bring out a window where I can see variable
>> values at runtime. I can get out the Immediate window, but that doesn't
>> help and in any case I'm not interested in typing in the same variable
>> multiple times!
>>
>> The help system is useless (not that I'm surprised). My web searches
>> turn up documents which tell me to click Add Watch from the View menu
>> (AFAIR), which doesn't exist.
>>
>> Please, is there someone out there who's solved this problem on Office X?
>> --
>> N Sanders, in New Zealand, DownUnder
>> Please reply to the group, thanks.
>
>
--
N Sanders, in New Zealand, DownUnder
Please reply to the group, thanks.