View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
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