LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Do Events

I tend toward always using it unless the form is unloaded immediately after it is shown.
--
Jim Cone
Portland, Oregon USA
(some useful Excel downloads at... http://excelusergroup.org/ )



"Robert Crandal"
wrote in message ...
So is it generally always a good idea to run code like this:
Userform1.Show
DoEvents ' Always after Userform1.show???
I never really noticed any problems with displaying modal
userforms until I put the Userform1.Show() code into
the Workbook_Open() subroutine and ran the file
in a server type system.




"Jim Cone"
wrote in message ...
DoEvents will usually clean things up after closing a form.
--
Jim Cone
Portland, Oregon USA

 
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
Alternative to IF Dave P[_2_] Excel Worksheet Functions 7 March 28th 08 05:00 PM
Workbook_Open Mangus Pyke Excel Programming 13 September 12th 06 06:15 PM
If alternative Busy Bee Excel Worksheet Functions 4 June 30th 06 12:53 AM
Workbook_Open () Bill Martin Excel Discussion (Misc queries) 12 December 20th 05 05:37 PM
Workbook_Open() will not run Jack Sheet Excel Programming 11 December 9th 04 09:04 AM


All times are GMT +1. The time now is 12:54 AM.

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"