Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Combining text and cell value to create a sentence | Excel Discussion (Misc queries) |