Limitations on Excel for Mac VBA
I thought it might be helpful if we listed some of the limitations of Excel on the Mac (regarding VBA), so that programmers can account for that if they are working in a cross-platform environment. And it will give us incentive to write to the MacBU at MS to request full-scale support.
Lack of support for hover
Brad also wrote:
Quote:
Two other clumsy workarounds for the lack of support for hover:
? myVariable in the Immediate window returns the current value
MsgBox myVariable displays the value on the screen
No Microsoft Scripting Runtime
This is another area of MS severely limiting the "cross-platform" work. Just discovered to tady when trying to run the Dictionary Object Model macros that Mac does not have Microsoft Scripting Runtime. :(
:dunno