View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
marcus[_3_] marcus[_3_] is offline
external usenet poster
 
Posts: 140
Default Slow Down the Macro to View

Hello Aria

This may be rather simplistic but if you place this line of code after
each line you want slowed it will take 2 seconds between each action.

Application.Wait Now + (TimeValue("00:00:02"))

Change to suit.

Take Care

Marcus

On Feb 1, 11:37 am, Aria <Aria wrote:
Hello,
Once a macro is triggered, it's incredibly fast. That's great and all.
However, what if I want the code to move slow enough so the other users
could see what it's doing every time ie. Cut and Paste (without Stepping
into the code and F8 through it all).

If it's possible, how would you do it?

Thanks,
Aria :)

*** Sent via Developersdexhttp://www.developersdex.com***