Do Events
in [Programming]
|
Prev: HELP: Add textbox to a frame at run time
Next: Two completely unrelated workbood. Why is it asking me about updating links? SOLVED!
From: Robert Crandal on 29 Jan 2010 15:33 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" <james.coneXXX(a)comcast.netXXX> wrote in message news:ug%23D3DQoKHA.1544(a)TK2MSFTNGP02.phx.gbl... > > DoEvents will usually clean things up after closing a form. > -- > Jim Cone > Portland, Oregon USA >
From: Jim Cone on 29 Jan 2010 17:49
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" <nobody(a)gmail.com> wrote in message news:XCH8n.1137$5n.538(a)newsfe23.iad... 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" <james.coneXXX(a)comcast.netXXX> wrote in message news:ug%23D3DQoKHA.1544(a)TK2MSFTNGP02.phx.gbl... > DoEvents will usually clean things up after closing a form. > -- > Jim Cone > Portland, Oregon USA |