Hi Loki....
Please try below..code try to edit.. how you want...
---(code is From Rajan verma)
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub Start()
Dim St As String
Dim Cell As Range
Set Cell = Range("L5")
St = Cell.Value
St = Trim(St)
St = St & " "
l = Len(St)
Do
Cell.Value = Right(St, l - 1) & Left(St, 1)
St = Right(St, l - 1) & Left(St, 1)
Sleep 100
Loop While 1
End Sub
On Wed, May 9, 2012 at 8:00 PM, Lokesh Loki <lokeshsmg2...@gmail.com> wrote:
> Hi Rajan,
>
> I did not get any results in the below link, could you please provide me
> the solution with the attached excel sheet.
>
> Its great for me to understand.
>
> Regards
> Lokesh.M
>
>
> On Wed, May 9, 2012 at 7:50 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
>
>> ** **
>>
>> Follow this Link
>> *
>> http://www.excelvbamacros.com/2012/04/adding-marquee-on-excel-worksheet.html
>> ***
>>
>> ** **
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
>> *Sent:* 09 May 2012 7:33
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Running text in excel****
>>
>> ** **
>>
>> Hi Experts,
>>
>> I have one small query i need a macro or else formula for running text in
>> excel.
>>
>> Please help on us and do the needful.
>>
>> Regards
>> Lokesh.M****
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com****
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
