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?

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

--

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


"pswanie" <(E-Mail Removed)> wrote in message news:5358CD49-F0BD-476D-AAD9-(E-Mail Removed)...
>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?