200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
i have a list of names and I want to scroll through them pausing for a couple of seconds at each one,on reaching the bottom of the list I want to return to the top and start again only stopping on my command to enable alterations then starting again at my command.
I be very grateful for any help on this.
thanks
Why not just use the mouse wheel in combination with some keyboard shortcuts...
Mouse wheel to scroll fast or slow.
Ctrl+Up and Ctrl+Down to quickly go to the top or bottom of the list.
Page Down and Page Up to quickly navigate through the list.
You can use this macro to automatically scroll:
Public interval As Date
Sub scroll_down()
interval = Now + TimeValue("00:00:01")
limit = Range("A" & Rows.Count).End(xlUp).Row
Selection.Offset(1, 0).Select
If Selection.Row >= limit Then Range("A1").Select
Application.OnTime interval, "scroll_down"
End Sub
Sub stop_scroll()
Application.OnTime EarliestTime:=interval, Procedure:="scroll_down", Schedule:=False
End Sub