How do i create moving text within a cell?

[dbouton]

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?

--
Don''t cry becuase I love you. Scream.

[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 :-)
------------------------------*------------------------------*----------------


"dbouton" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
> --
> Don''t cry becuase I love you. Scream.

[Biff]

>You cannot do this.

And hopefully, we never will!

Biff

"Ken Wright" <[email protected]> wrote in message
news:O%[email protected]...
> 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 :-)
> ------------------------------*------------------------------*----------------
>
>
> "dbouton" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>> --
>> Don''t cry becuase I love you. Scream.
>
>

[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




"dbouton" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
> --
> Don''t cry becuase I love you. Scream.

[Biff]

>generally discouraged.

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

Biff

"CLR" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
>
> "dbouton" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>> --
>> Don''t cry becuase I love you. Scream.
>
>

[Ken Wright]

LOL - amen to that :-)


"Biff" <[email protected]> wrote in message
news:[email protected]...
> >You cannot do this.
>
> And hopefully, we never will!
>
> Biff
>
> "Ken Wright" <[email protected]> wrote in message
> news:O%[email protected]...
>> 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 :-)
>> ------------------------------*------------------------------*----------------
>>
>>
>> "dbouton" <[email protected]> wrote in message
>> news:[email protected]...
>>> 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?
>>>
>>> --
>>> Don''t cry becuase I love you. Scream.
>>
>>
>
>

[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.....................

"CLR" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
>
> "dbouton" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>> --
>> Don''t cry becuase I love you. Scream.
>
>

[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