<div>
Hi Harish, <br />
Thank you for helping me with the code. Do while worked better than do until..<br />
<br />

</div>


Hi Harish,
Thank you for helping me with the code. Do while worked better than do until..



<div>
Thanks :)<br />
<br />
Yes.. that should have been While .... Wend
</div>


Thanks :)

Yes.. that should have been While .... Wend

<div>
<div class="content wysiwyg-content">
I want to create a do untill loop in vba, which will take hours as input and continue with steps in the loop till the until criteria is met. Below the code I have so far<br />
<br />
dim inout<br />
Dim timenow<br />
<br />
inout = 24 &nbsp;'time in hours.<br />
<br />
timenow = Now()<br />
<br />
<br />
Do Until i = timenow + inout<br />
Loop<br />
<br />
It does not work..someone has better idea??<br />
<br />
Thank you in advance.
</div>
</div>


I want to create a do untill loop in vba, which will take hours as input and continue with steps in the loop till the until criteria is met. Below the code I have so far

dim inout
Dim timenow

inout = 24  'time in hours.

timenow = Now()


Do Until i = timenow + inout
Loop

It does not work..someone has better idea??

Thank you in advance.

Time loop.

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.