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.
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 :-)
------------------------------*------------------------------*----------------
"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.
>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.
>
>
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.
>>
>>
>
>
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
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.
>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.
>
>
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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks