a fairly simple way is to set up the whole text in one cell and a
counter in another cell. then in the display cell use the formula
=MID(F21,E21,99) where F21 contains the text, and e21 the counter.
in vba set-up a timer loop : simple do loop to an end-interval time
using doevents to consume time then increment the counter.
It will scroll but jerkily.
If you want a nice smooth scroll it is a similar technique on the timer
but using a VBA control over the cell andthen scroll a text box within
the frame.
Do make sure you have an escape route from the timer
It is always good to something mad.
regards
--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=505128