View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ForSale[_53_] ForSale[_53_] is offline
external usenet poster
 
Posts: 1
Default Automatically close a userform


The following isn't working. what am i doing wrong?

UserForm2.Show
Application.Wait (Now() + TimeValue("0:00:04"))
Unload UserForm2

I'm trying to pop up a userform for 4 seconds, then close it.
I initally added some basic shapes - a rectangle and three arrows - an
did the same thing. it worked the first time, but then they wouldn'
pop up anymore, but that's not important.
thanks

--
ForSal
-----------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...fo&userid=1189
View this thread: http://www.excelforum.com/showthread.php?threadid=26566