View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rockee052[_19_] Rockee052[_19_] is offline
external usenet poster
 
Posts: 1
Default Macro and slowing a progress bar.

I know that my progress bar was not needed, i just wanted to see how on
works in action. What I used to slow it down was:

newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 3
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime

Work fin

--
Message posted from http://www.ExcelForum.com