[RESOLVED] Wait Until Form is Close Before Continuing

[dethredic]

So I have something like this:

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:

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.

[techgnome]

Try .ShowDialog instead of .Show

-tg

[dethredic]

sweet, thanks.