Re: $$Excel-Macros$$ scrolling and blinking label caption

2011-09-06 Thread Shankar Bheema
Thank so muchh. Noorainji On Tue, Sep 6, 2011 at 11:48 AM, NOORAIN ANSARI 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) >

Re: $$Excel-Macros$$ scrolling and blinking label caption

2011-09-05 Thread NOORAIN ANSARI
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 accordanc

Re: $$Excel-Macros$$ scrolling and blinking label caption

2011-09-05 Thread Bheema Shankar
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 wrote: > Dear Bheema, > > Please see attached sheet it it help to u.. > -- > Thank

Re: $$Excel-Macros$$ scrolling and blinking label caption

2011-09-05 Thread dguillett1
A bit more compact. Year does NOT matter Private Sub ScrollBar1_Change() UserForm1.Label1 = Format(DateSerial(2011, ScrollBar1, 1), "mmm") End Sub From: NOORAIN ANSARI Sent: Sunday, September 04, 2011 9:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ scr

Re: $$Excel-Macros$$ scrolling and blinking label caption

2011-09-04 Thread NOORAIN ANSARI
Dear Bheema, Please see attached sheet it it help to u.. -- Thanks & regards, Noorain Ansari http://Excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* On Mon, Sep 5, 2011 at 7:29 AM, Bheema Shankar wrot

Re: $$Excel-Macros$$ scrolling and blinking label caption

2011-09-04 Thread XLS S
Userforms have 6 properties that relate directly to ScrollBars. Set the .ScrollBars property to 2 Now, set the .ScrollTop to 0 (So it will appear always at the top of the form) and finally, you must change the .ScrollBarHeight to something... for example, If the UserForm height is 100, try settin

$$Excel-Macros$$ scrolling and blinking label caption

2011-09-04 Thread Bheema Shankar
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 link