0

What happens to a modeless Userform if I do this:

Sub testUIfrm()
Dim UIf As UIFrm

Set UIf = New UIFrm

With UIf
.Show
End With

End Sub

The sub runs until End Sub and will then terminate. The UserForm is still shown. But what happens with the UIf Object? According to my logic it should be terminated as soon as End Sub is hit. But the UIf is not terminated. (I have inserted a msgbox in the terminate event and this doesn't show.)

So what is going on here when End Sub is executed?

This thing seems very fishy to me..

braX
  • 11,506
  • 5
  • 20
  • 33

0 Answers0