Dear sir
u done good help me.. lot of thanks.u gave code its work corretly.
what need i done with u code withsome changes. anyhow u r my teacher
in this matter. once again i want say thanks with sorry for my
english.
Regards:
kavi
On Jan 20, 5:18 pm, Paul Schreiner <schreiner_p...@att.net> wrote:
> try this:
>
> Sub test()
> Dim stoptime, cnt As Long
> stoptime = Now + TimeValue("00:00:05") ' 5 seconds from "Now"
> While Now < stoptime
> cnt = cnt + 1
> Application.StatusBar = "Cnt: " & cnt
> Wend
> MsgBox "done"
> Application.StatusBar = False
> End Sub
>
> Paul
>
> ________________________________
> From: memonkavi <memonk...@gmail.com>
> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> Sent: Wed, January 20, 2010 12:58:07 AM
> Subject: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?
>
> sir
> ex
> code
> do
> calculate
> loop until -----------------------
> here i want set a time limit
> pls help me
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links
> :http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads
> athttp://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
