ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   display userform4 for 30sec's (https://www.excelbanter.com/excel-programming/405101-display-userform4-30secs.html)

pswanie

display userform4 for 30sec's
 
i got a module to check if internet connection available. this takes about 30
to 60 sec's to check. when established userform1 load and the user can
continue.

i made userform4 with label1 to display when opening the workbook. in
workbook open i got

load userform4
call check4internet
unload userform4
load userform1

userform4 does not unload. how can i put a "time delay" userform while sub
check4internet is running?

Ron de Bruin

display userform4 for 30sec's
 
See
http://www.j-walk.com/ss/excel/tips/tip39.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pswanie" wrote in message ...
i got a module to check if internet connection available. this takes about 30
to 60 sec's to check. when established userform1 load and the user can
continue.

i made userform4 with label1 to display when opening the workbook. in
workbook open i got

load userform4
call check4internet
unload userform4
load userform1

userform4 does not unload. how can i put a "time delay" userform while sub
check4internet is running?



All times are GMT +1. The time now is 10:07 PM.

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