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?