Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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*** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom View show is very slow | Excel Discussion (Misc queries) | |||
Macro help, very slow | Excel Programming | |||
Very slow macro | Excel Programming | |||
Macro slow down | Excel Programming | |||
Macro it's very Slow .... | Excel Programming |