{"id":133,"date":"2015-10-24T12:16:59","date_gmt":"2015-10-24T12:16:59","guid":{"rendered":"http:\/\/99excel.com\/?p=133"},"modified":"2021-05-14T16:09:21","modified_gmt":"2021-05-14T16:09:21","slug":"do-until","status":"publish","type":"post","link":"https:\/\/99excel.com\/home\/do-until\/","title":{"rendered":"Do Until"},"content":{"rendered":"<p>Again this is very similar to the <strong>Do While<\/strong> Loop we just used above in that it will check the condition <strong>BEFORE<\/strong> it enters the Loop. If the Value of iMyNumber is 0 (zero) when it reaches the Loop, the difference is the <strong>Do While<\/strong> would keep adding the number one to iMyNumber until it reached 1000.<\/p>\n<p>&nbsp;<\/p>\n<p>In the <strong>Do Until<\/strong> it would never even enter the Loop because the condition MyNumber &lt; 1000 has been met already ie; iMyNumber is 0 (zero).<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Sub My_DoUntil()<\/p>\n<p>Dim iMyNumber as Integer<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Do until<\/strong> iMyNumber &lt; 1000<\/p>\n<p>iMyNumber=1+iMyNumber<\/p>\n<p><strong>\u00a0\u00a0\u00a0 Loop<\/strong><\/p>\n<p>End Sub<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Again this is very similar to the Do While Loop we just used above in that it will check the condition BEFORE it enters the Loop. If the Value of iMyNumber is 0 (zero) when it reaches the Loop, the difference is the Do While would keep adding the number one to iMyNumber until it &#8230; <a title=\"Do Until\" class=\"read-more\" href=\"https:\/\/99excel.com\/home\/do-until\/\" aria-label=\"More on Do Until\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"predecessor-version":[{"id":890,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/133\/revisions\/890"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}