How to display a scrolling roll of names?

Question

I have to organize a roll call vote with over 100 people.

The next 4 or 5 names must be displayed on a screen, so that voters see their name and prepare to speak up. Ideally, this is a scrolling list that can go faster/slower, or that can be paused/resumed.

How can I do that? With Impress/Powerpoint? Calc/Excel? any another program?

One requirement is for the scrolling list to take little time to prepare. Here's why: while 200 names are registered, only about 100 people will show up. So the scrolling list can be prepared beforehand, but some names will be removed at the last minute.

Answer 1

Try this code:

Dim iFlag As Boolean

Dim i As Integer

Sub MoveDown()

If iFlag Then

iFlag = False

Else

If i = 12 Then 'how many pages you need

i = 0

Else

i = i + 1

End If

Range("A" & i * 28 + 17).Select

Application.OnTime Now + TimeValue("0:0:2"), "movedown"

End If

End Sub

Sub StopM()

iFlag = True

End Sub