Interesting little tidbit, I never knew this worked..
Dim d AsBooleanPrivateSubCommand1_Click()
d =TrueEndSubPrivateSubForm_Load()
Me.Visible =TrueMe.Refresh
DoEvents
d =FalseFor i =0To100While1
DoEvents
Me.Refresh
If d ThenExitForWendNext
MsgBox "done!"EndSub