display userform4 for 30sec's

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pswanie - 27 Jan 2008 21:30 GMT

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?

Reply to this Message

Ron de Bruin - 27 Jan 2008 21:36 GMT

See
http://www.j-walk.com/ss/excel/tips/tip39.htm

Signature

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

>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
[quoted text clipped - 10 lines]
> userform4 does not unload. how can i put a "time delay" userform while sub
> check4internet is running?

Reply to this Message