Re: $$Excel-Macros$$ Re: blink the Label caption

2011-09-08 Thread Shankar Bheema
Deepak ji I want to blink the text on the Label object on form initialize event. On Thu, Sep 8, 2011 at 11:04 AM, Deepak Pal Singh wrote: > It won't work... Just want to confirm whether do you want to blink your > text in a label or in cells...?? > > Regards > Deepak > > On Wed, Sep 7, 2011 at

Re: $$Excel-Macros$$ Re: blink the Label caption

2011-09-07 Thread Deepak Pal Singh
It won't work... Just want to confirm whether do you want to blink your text in a label or in cells...?? Regards Deepak On Wed, Sep 7, 2011 at 7:30 PM, Bheema Shankar wrote: > Deepak ji > > I made little changes to your code to blink my label caption on the > form: > > > Dim MyArray() As Variant

$$Excel-Macros$$ Re: blink the Label caption

2011-09-07 Thread Bheema Shankar
Deepak ji I made little changes to your code to blink my label caption on the form: Dim MyArray() As Variant Dim i As Integer, R As Long, C As Integer Dim vText As String Dim DelayLoop1 As Long, DelayLoop2 As Long Sub StartBlinking() vText = Label1.Caption For i = 1 To Len(vText) ReDim Prese

$$Excel-Macros$$ Re: blink the Label caption

2011-09-07 Thread Bheema Shankar
thank you deepu On Sep 7, 5:42 pm, deepu wrote: > Though MS-Excel is not an application where you can make high class > animation.. but it depends on your creativity.. how do you utilize > your knowledge to bring such an effects in Excel.. Below is the code > that I've create, you can modify it a

$$Excel-Macros$$ Re: blink the Label caption

2011-09-07 Thread deepu
Though MS-Excel is not an application where you can make high class animation.. but it depends on your creativity.. how do you utilize your knowledge to bring such an effects in Excel.. Below is the code that I've create, you can modify it according to your requirements, you might want to change fo