Slow Down the Macro to View
 

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 Developersdex http://www.developersdex.com ***

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***

Slow Down the Macro to View
 

check vba help for the wait method. perhaps put the code in a separate
subroutine and call it whenever you want it to slow down. For example, the
following test should activate each worksheet in the book with a 5 second
pause in between.


Sub test()
Dim wksTemp As Worksheet

For Each wksTemp In Sheets
wksTemp.Activate
Call TimeOut(0, 0, 5)
Next wksTemp
End Sub

Sub TimeOut(lngHour As Long, _
lngMinute As Long, _
lngSecond As Long)
Dim dblWaitTime As Double

dblWaitTime = Now() + TimeSerial(lngHour, _
lngMinute, lngSecond)

Application.Wait dblWaitTime

End Sub

"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 Developersdex http://www.developersdex.com ***

Slow Down the Macro to View
 

Thank-you so much JMB and Marcus,
Both are very good choices. I will try both of your suggestions. This
will help my work greatly.

Thanks again,
Aria :)


*** Sent via Developersdex http://www.developersdex.com ***

Slow Down the Macro to View
 

Aria,
Not sure if this is practical, but have you looked at a product like AutoIt,
http://www.autoitscript.com/.
As I remember, you can set the play back speed to the same as the recording.
However, I believe it works on screen coordinates, so if the users have
different resolutions, location of windows etc, you will not get reliable
results.
If this is to used on the same system, then it may work.

OK, not really an Excel/VBA solution, but...

NickHK

<Aria wrote in message ...
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 Developersdex http://www.developersdex.com ***