The VBE has a Break control (figure 2), but this is not available because the message box is modal. Many laptop devices do not have a Break|Pause key creating a problem with the Ctrl + Break combination. Click to exit loop, or to see the code at the current Step Point in the VBE module window.įig 2: Code execution interrupter dialog - activated by the Ctrl + Break keyboard combination. See the following indicators below for three possible techniques.Ĭtrl + Break To break out of a loop, the conventional technique is the keyboard Ctrl + Break combination.Ĭtrl + Break will display the dialog box in figure 2.
Fig 1: Simple message box demo with 999 click sequence - clicking the Close button will only continue the sequence
When clicked, the Close button in figure 1 has the same effect as the OK button. Suppose that a message box (MsgBox) is part of the statement structure in a For.Next loop. Quick guide - how to a message box when part of a loop Break out of a Loop while Message Box is activeĠ.
0 kommentar(er)
