View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
tony h
 
Posts: n/a
Default How do i create moving text within a cell?


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