software

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.

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 :-)
------------------------------*------------------------------*----------------quot;dboutonquot; gt; wrote in message
...
gt; I've scoured the net looking for this answer. I'd like to have text within
gt; a
gt; cell moving just like a scrolling marque. Is this possible? Would someone
gt; provide help with this?
gt;
gt; --
gt; Don''t cry becuase I love you. Scream.
gt;You cannot do this.

And hopefully, we never will!

Biff

quot;Ken Wrightquot; gt; wrote in message
...
gt; You cannot do this.
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------*------------------------------*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------*------------------------------*----------------
gt;
gt;
gt; quot;dboutonquot; gt; wrote in message
gt; ...
gt;gt; I've scoured the net looking for this answer. I'd like to have text
gt;gt; within a
gt;gt; cell moving just like a scrolling marque. Is this possible? Would someone
gt;gt; provide help with this?
gt;gt;
gt;gt; --
gt;gt; Don''t cry becuase I love you. Scream.
gt;
gt;
Technically, quot;motionquot; 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

quot;dboutonquot; gt; wrote in message
...
gt; I've scoured the net looking for this answer. I'd like to have text within
a
gt; cell moving just like a scrolling marque. Is this possible? Would someone
gt; provide help with this?
gt;
gt; --
gt; Don''t cry becuase I love you. Scream.
gt;generally discouraged.

It's a spreadsheet, for cryin out loud, not a video game! lt;vbggt;

Biff

quot;CLRquot; gt; wrote in message
...
gt; Technically, quot;motionquot; is possible in Excel through the use of Macros and
gt; time-delays, however it is very resource intensive, and generally
gt; discouraged.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;dboutonquot; gt; wrote in message
gt; ...
gt;gt; I've scoured the net looking for this answer. I'd like to have text
gt;gt; within
gt; a
gt;gt; cell moving just like a scrolling marque. Is this possible? Would someone
gt;gt; provide help with this?
gt;gt;
gt;gt; --
gt;gt; Don''t cry becuase I love you. Scream.
gt;
gt;
LOL - amen to that :-)quot;Biffquot; gt; wrote in message
...
gt; gt;You cannot do this.
gt;
gt; And hopefully, we never will!
gt;
gt; Biff
gt;
gt; quot;Ken Wrightquot; gt; wrote in message
gt; ...
gt;gt; You cannot do this.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt; Ken....................... Microsoft MVP - Excel
gt;gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;gt;
gt;gt; ------------------------------*------------------------------*----------------
gt;gt; It's easier to beg forgiveness than ask permission :-)
gt;gt; ------------------------------*------------------------------*----------------
gt;gt;
gt;gt;
gt;gt; quot;dboutonquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; I've scoured the net looking for this answer. I'd like to have text
gt;gt;gt; within a
gt;gt;gt; cell moving just like a scrolling marque. Is this possible? Would
gt;gt;gt; someone
gt;gt;gt; provide help with this?
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Don''t cry becuase I love you. Scream.
gt;gt;
gt;gt;
gt;
gt;
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.....................

quot;CLRquot; gt; wrote in message
...
gt; Technically, quot;motionquot; is possible in Excel through the use of Macros and
gt; time-delays, however it is very resource intensive, and generally
gt; discouraged.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;dboutonquot; gt; wrote in message
gt; ...
gt;gt; I've scoured the net looking for this answer. I'd like to have text
gt;gt; within
gt; a
gt;gt; cell moving just like a scrolling marque. Is this possible? Would someone
gt;gt; provide help with this?
gt;gt;
gt;gt; --
gt;gt; Don''t cry becuase I love you. Scream.
gt;
gt;

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: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=505128