Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA delay timer in Excel 2013
@combo, I may have miscommunicated. When I execute the application.waitsubroutine. It works as intended. However, while running there will be times when I want to pause or stop the scrolling to review data in a particular column (this will be used as a dashboard). In this case, Excel will...- djamie
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA delay timer in Excel 2013
@combo, Thanks! That did exactly what I needed. Follow up question... is there a subroutine I can map to a button that allows me to break Application.Waitwithout throwing error similar to (Ctrl+Break)? Thanks djamie- djamie
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA delay timer in Excel 2013
I am trying to introduce a delay timer (10s) before calling a subroutine that will scroll my data by 1 column each loop. However, when I run the subroutine, the timer is ignored and the columns are scrolled without delay. Finally I get the following error for each instance (56) that loop is...- djamie
- Thread
- Replies: 11
- Forum: VBA Visual Basic for Applications (Microsoft)
