Application.OnTime is designed for such uses. The Application.Wait
halts all code, where as OnTime allows the sequential flow of the
macro.
Code below....
Sub Start()
Range("G3").Value = Now
If Range("G3").Value = Range("E3").Value Then
MsgBox "Time's Up", vbInformation
Else
Application.OnTime Now + TimeValue("00:00:01"), "Start"
End If
End Sub
Regards,
Sam Mathai Chacko (GL)
On Aug 21, 2:23 am, hanumant shinde <arsfan2...@yahoo.co.in> wrote:
> AWESOME and very easy . i was thinking in wrong direction. thanks Rajan
>
>
>
>
>
> >From: Rajan_Verma <rajanverma1...@gmail.com>
> >To: excel-macros@googlegroups.com
> >Sent: Fri, 19 August, 2011 5:51:44 PM
> >Subject: RE: $$Excel-Macros$$ Countdown
>
> >Try this
> >From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
> >Behalf Of Dinesh Prajapati
> >Sent: Thursday, August 18, 2011 7:15 PM
> >To: excel-macros@googlegroups.com
> >Subject: $$Excel-Macros$$ Countdown
>
> >Hi,
>
> >Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel.
>
> >Rgds
> >Dinesh
> >--
> >----------------------------------------------------------------------------------
>
> >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
> --
> >----------------------------------------------------------------------------------
>
> >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
--
----------------------------------------------------------------------------------
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
