How do i create moving text within a cell?

[Guest]

I've scoured the net looking for this answer. I'd like to have text within a
cell moving just like a scrolling marque. Is this possible? Would someone
provide help with this?

 

[Ken Wright]

You cannot do this.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Biff]

You cannot do this.

And hopefully, we never will!

Biff

 

[CLR]

Technically, "motion" is possible in Excel through the use of Macros and
time-delays, however it is very resource intensive, and generally
discouraged.

Vaya con Dios,
Chuck, CABGx3

 

[Biff]

generally discouraged.

It's a spreadsheet, for cryin out loud, not a video game! <vbg>

Biff

 

[Ken Wright]

LOL - amen to that

And hopefully, we never will!

Biff

 

[Ken Wright]

Not whilst in Edit mode though, and to have a cells contents scroll, I'm
pretty sure you would effectively be in edit mode somehow.

Regards
Ken.....................

 

[tony h]

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