How do I delay the progress with a second cause I want to use a counting clock but i cant use a one second break in my loop.
And is their a possebility to export to a exe file?
please help me
Foaly
I'm not sure what you mean by "I can't use a one second break in my loop" - possibly you mean you can't use this! But have you tried using Timer? This gives the amount of seconds which have passed since midnight. You can use this to create a pause like so:
Dim start, pause
start = timer 'set the start time
pause = 15 ' set the pause to be 15 seconds (or whatever you prefer)
do while timer < start + pause 'loop through this until the duration is complete
doevents ' allow other events to continue during the pause
loop
Ehm well it works this way better because I can work while it's busy. But I just heard vba is not compatible with so i cant make it stand alone and that's a bigger problem :-(.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.