ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   unload userform (https://www.excelbanter.com/excel-programming/413293-unload-userform.html)

shiro[_2_]

unload userform
 
Hi all,
how to automatically unload user forms
after 5 seconds from it's loading time.
( Just for a application welcome form )



Howard Kaikow

unload userform
 


--
http://www.standards.com/; See Howard Kaikow's web site.
"shiro" wrote in message
...
Hi all,
how to automatically unload user forms
after 5 seconds from it's loading time.
( Just for a application welcome form )


Dim datNow As Date
txtMessage.Locked = True
datNow = Now + TimeValue("00:00::05")
Do Until datNow < Now
DoEvents
Loop
Unload Me




All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com