How do i create moving text within a cell?
 

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.

How do i create moving text within a cell?
 

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" wrote in message
...
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.

How do i create moving text within a cell?
 

You cannot do this.

And hopefully, we never will!

Biff

"Ken Wright" wrote in message
...
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" wrote in message
...
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.

How do i create moving text within a cell?
 

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" wrote in message
...
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.

How do i create moving text within a cell?
 

generally discouraged.

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

Biff

"CLR" wrote in message
...
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" wrote in message
...
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.

How do i create moving text within a cell?
 

LOL - amen to that :-)


"Biff" wrote in message
...
You cannot do this.

And hopefully, we never will!

Biff

"Ken Wright" wrote in message
...
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" wrote in message
...
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.

How do i create moving text within a cell?
 

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" wrote in message
...
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" wrote in message
...
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.

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