Close userform after 2 seconds
 

I load an userform when the workbook opens. Does anybody know some code which
automatic can unload the userform after some seconds ?

Close userform after 2 seconds
 

Kent,
Try this:

Sub ShowForm()
UserForm1.Show vbModeless
Application.OnTime Now + TimeValue("00:00:02"), "Unload_Form"
End Sub

Sub Unload_Form()
UserForm1.Hide
End Sub

"Kent" wrote:

I load an userform when the workbook opens. Does anybody know some code which
automatic can unload the userform after some seconds ?