How to Exit a "Do While" Loop
Posted by Dexter on August 30, 2001 11:56 AM
I have a simple application that permits an operator to select from a list of choices in a dialog box; the choice copies data into the active cell. The active cell subsequently moves down one row, and another selection and copy can be made.
I would like to change this loop from a "For-Next" to a "Do While" or a "Do Until" with an option button in the dialog box that permits the operator to quit the routine at any time. Here is the existing code:
For DayToSched = 1 to 31
Any help on this would be greatly appreciated