October 2008
M T W T F S S
« Sep   Nov »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archives

Archive for October, 2008

Implementing Cancels in VBA Loops

( General )

I like to allow users the opportunity to cancel out of long loops if they need to. I use a global variable, something like gbCanacel, which gets set to True when the user clicks the Cancel button.

Then my looping checks for this with an if statement, normally the last thing inside the next/loop statement. […]