OS X VBA user and needs help with the Immediate Window

[sageT]

I used to be a power VBA user in Windows, but there's no Watch Pane in the Mac version and I can't get the Immediate Window to tell me the value of my variables. As such, I can't debug because i have no idea what the formula results are!!!

Can someone PLEASE give me an example so I can understand how this thing works? Thanks!

 

[jrbarnett]

I don't know the Office X at all, but a few things to try:

1. Type ? Variablename in the debug window.
2. Hover your mouse over the variable and see if it comes up in a Tooltip (does under XP).

John