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