View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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 ?