$$Excel-Macros$$ Re: Userform for 10 secs

2009-09-13 Thread Harmeet Singh
most welcome Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 14, 2009 at 9:40 AM, suresh k wrote: > Hi Harmeet, > > thank you. Now its working. > I was using useform activate function. Thats y it was not working. > > Anyways thank you so much for your help. > > > > On

$$Excel-Macros$$ Re: Userform for 10 secs

2009-09-13 Thread suresh k
Hi Harmeet, thank you. Now its working. I was using useform activate function. Thats y it was not working. Anyways thank you so much for your help. On Mon, Sep 14, 2009 at 9:17 AM, Harmeet Singh wrote: > *Created a file for ur ease**see attached file..* > > Thanks & Regards, > > Harmee

$$Excel-Macros$$ Re: Userform for 10 secs

2009-09-13 Thread suresh k
Hi Harmeet, Thanks for your reply. In this case, after running the userform. I need to click on that. And the time will count from that time. So If I dont click anywhere, it will not close. Any suggestions.. Regards, Suresh On Sat, Sep 12, 2009 at 2:42 AM, Harmeet Singh wrote: > Below code ma

$$Excel-Macros$$ Re: Userform for 10 secs

2009-09-11 Thread Harmeet Singh
Below code may help u *Sub um()* *If Application.Wait(Now + TimeValue("0:00:10")) Then* *MsgBox "Time expired" ' or write "Unload Me" here* *End If* *End Sub* Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Sep 11, 2009 at 10:23 AM, suresh k wrote: > Hi, >