[RESOLVED] Wait Until Form is Close Before Continuing

So I have something like this:

Code:

---

For Each Entry In CheckedListBox1.CheckedItems
    SheetName = Entry.ToString()
    Form2.Show()
 
Next

---

but I don't want to continue the loop until Form2 is closed. I tried something like this:

Code:

---

For Each Entry In CheckedListBox1.CheckedItems
    SheetName = Entry.ToString()
    Form2.Show()
    Do
          If Form2.Visible = False Then
              Exit Do
          End If
    Loop
Next

---

But that just froze everything and used up all my CPU.

Try .ShowDialog instead of .Show

-tg

sweet, thanks.