Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells display as R5C5. How do I change it to display E5? FinanceTrainer Excel Discussion (Misc queries) 2 December 14th 09 08:27 PM
How to display remaining txt file which overflowed MsgBox display? EagleOne Excel Discussion (Misc queries) 1 November 2nd 06 01:10 PM
Why does my formula bar display a lengthy string, but my cells display #####? [email protected] Excel Programming 2 August 23rd 06 06:43 PM
Conditional display - IF cell is blank, display next used row! Patti[_7_] Excel Programming 2 March 28th 06 10:33 PM
Numbers display as decimal, i.e. enter 123 display 1.23 IGH219 Setting up and Configuration of Excel 1 June 16th 05 09:16 PM


All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"