How do I create scrolling text

[Mikros]

I'm new to visual basic but trying to learn more...
I'm currently working in excel trying to get a macro that will scroll down through a list of cells. The problem I'm running into is that I need the macro to stop for 1 second at each cell before continuing to scroll down.

Any ideas?

-Jack Arthmor

[kadghar]

... need the macro to stop for 1 second at each cell before continuing to scroll down.

The problem with VBA is that you don't have timers, but you can use a DO loop with a DoEvents in it, let's say you want a macro that selects cell "A1" and after that each second it selects the one below, something like this should do:

Sub test()
Dim i As Long
Cells(1,1).Select
t = Timer
i = 2
Do
    If t = Timer Then
        t = Timer + 1
        i = i + 1
        Cells(i,1).Select
    End If
    DoEvents
Loop
End Sub

Please note it's an endless loop, so if you want to stop it just press Ctrl+Brk
or write instead of loop something like

Loop Until i = 10 (to repeat it only 10 times), or
Loop Until Cells(i,1) = "" (to repeat it until it finds an empty cell)

HTH