View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajliaks[_30_] ajliaks[_30_] is offline
external usenet poster
 
Posts: 1
Default Vba - automaticaly closing userform

Hi all,

i need to close the userform after 2 seconds.
Could anybody help me?
Thanks.

Iam trying something like this:

Private Sub UserForm_Initialize()
Dim cTime As Long
Dim WSH As Object

Set WSH = CreateObject("WScript.Shell")
cTime = 1

Wait cTime '?????

Unload Me
End Sub


---
Message posted from http://www.ExcelForum.com/