Visual Basic Excel Mac

L

landeisb

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?
 
J

Jim Gordon MVP

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


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?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top