ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   do events? background events (https://www.excelbanter.com/excel-programming/358689-do-events-background-events.html)

cereldine[_15_]

do events? background events
 

In the past i have used a statement when performing a long procedure
that keeps the background windows events running? I can't for the life
of me remember what it is tho. I'm sure it was something like Do events
but this does not seem right, i used this statement in access but am
sure it must exist in excel too

ANyone know what i'm talking about?


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=532218


Bob Phillips[_6_]

do events? background events
 
DoEvents (no space) is used to yield so that other processes can get a look
in.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cereldine" wrote
in message ...

In the past i have used a statement when performing a long procedure
that keeps the background windows events running? I can't for the life
of me remember what it is tho. I'm sure it was something like Do events
but this does not seem right, i used this statement in access but am
sure it must exist in excel too

ANyone know what i'm talking about?


--
cereldine
------------------------------------------------------------------------
cereldine's Profile:

http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=532218





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com