Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 08:26 PM
Wrapping in Excel (fitting many lines of text in cell to print rig hd3017 Excel Discussion (Misc queries) 3 December 8th 05 01:19 AM
Cell text based on 4 condition test Bob Wall Excel Worksheet Functions 3 November 16th 05 07:34 PM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Combining text and cell value to create a sentence StephanieH Excel Discussion (Misc queries) 4 June 13th 05 11:53 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"