Visual Basic Excel Mac

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

landeisb@comcast.net - 10 Oct 2007 22:52 GMT

I have recently moved from windows excel to mac. When I have run my
macros written in visual basic on windows I can view the movement of
the cursor. Now on the mac even though I have added the code
Application.Screenupdating=true the screen does not update during
execution of the macro. The macro runs fine I just don't see the
results until the macro completes. Any suggestions?

Reply to this Message

Jim Gordon MVP - 11 Oct 2007 00:21 GMT

Hi,

Liberally sprinking with DOEVENTS at appropriate places can help. If
userforms need screen updating you can force it to happen with the
userform.REFRESH command.

-Jim

Quoting from "landeisb@comcast.net" <landeisb@comcast.net>, in article
1192053125.290288.286080@k79g2000hse.googlegroups.com, on [DATE:

> I have recently moved from windows excel to mac. When I have run my
> macros written in visual basic on windows I can view the movement of
> the cursor. Now on the mac even though I have added the code
> Application.Screenupdating=true the screen does not update during
> execution of the macro. The macro runs fine I just don't see the
> results until the macro completes. Any suggestions?

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Mac Forum / Applications / Excel / October 2007

Visual Basic Excel Mac