Thank so muchhhhhhhhhhhhhh. Noorainji On Tue, Sep 6, 2011 at 11:48 AM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote:
> Dear Bheema, > > See attached sheet..................... > > *Private Sub UserForm_activate() > marqueeText = " This is a test of the Marquee" > Do > For m = 1 To Len(marqueeText) > UserForm1.Label1.Caption = Mid(marqueeText, m, 10) > For i = 60 To 55 Step -1 > 'Change in accordance with value of label1.left > UserForm1.Label1.Left = i > DoEvents > t = Timer > While (Timer < t + 0.01) > 'Here you can adjust the speed of the marquee > Wend > Next i > Next m > Loop > End Sub > > * > On Mon, Sep 5, 2011 at 9:34 PM, Bheema Shankar <shankar.n...@gmail.com>wrote: > >> thank you for replying me. But scrolling means not scroll bar. its >> the caption text of the label have to move from left to right of the >> screen. just like marquee function in HTML >> >> On Sep 5, 7:52 am, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: >> > Dear Bheema, >> > >> > Please see attached sheet it it help to u.. >> > -- >> > Thanks & regards, >> > Noorain >> > Ansarihttp://Excelmacroworld.blogspot.com/<http://excelmacroworld.blogspot.com/> >> <http://excelmacroworld.blogspot.com/> >> > *http://noorain-ansari.blogspot.com/*< >> http://noorain-ansari.blogspot.com/> >> > >> > On Mon, Sep 5, 2011 at 7:29 AM, Bheema Shankar <shankar.n...@gmail.com >> >wrote: >> > >> > >> > >> > >> > >> > >> > >> > > hai to all, >> > >> > > I need to scroll and blink label caption on the userform. I am using >> > > Excel 2003. Pls guide me how to do this ? >> > >> > > -- >> > >> > > >> --------------------------------------------------------------------------- >> ------- >> > > Some important links for excel users: >> > > 1. Follow us on TWITTER for tips tricks and links : >> > >http://twitter.com/exceldailytip >> > > 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> > >> > > To post to this group, send email to excel-macros@googlegroups.com >> > >> > > <><><><><><><><><><><><><><><><><><><><><><> >> > > Like our page on facebook , Just follow below link >> > >http://www.facebook.com/discussexcel >> > >> > >> > >> > Scroll Bar-Label Blinking.xlsm >> > 23KViewDownload >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel