RE: Funcitonality to pause macro?!

Tech-Archive recommends: Fix windows errors by optimizing your registry

The userform is taking records from a database, going out to the internet and
getting data, then bringing that data back down to update the database.

But it could take a long time because of the number of records in the
database.

Tony

"JLGWhiz" wrote:

One more thought, if he just wants to stop the macro to use the computer for
some other purpose, tell him abou Ctrl + Pause/Break. That will stop it and
then when he is ready, he can just restart the macro.

"Webtechie" wrote:

I've created a userform based application. The application processes
thousans of records and can go for awhile (4 days or more).

The problem is that the client at times may need to pause the processing for
some reason. He has asked me to create the functionality to pause the macro?

I'm not sure how to pause the macro while it is processing. I have a
progressbar that is running. As each record is processed, the progressbar
increments.

Any ideas how to pause the macro while it is processing? Create Key stroke
event?

Thanks.

Tony
.

Relevant Pages

  • RE: Funcitonality to pause macro?!
    ... A userform is showing the progress. ... userform and progressbar have the focus. ... Does the user want to pause without breaking the sequence of records being ... user simply halt the macro with Ctrl + Pause/Break? ...
    (microsoft.public.excel.programming)
  • RE: Funcitonality to pause macro?!
    ... I'd like to have the userform have a button or something that can be pressed ... to pause the macro while it is running. ... Not sure how to have the progressbar running, ... and have a button be able to pause the macro if needed. ...
    (microsoft.public.excel.programming)
  • Re: Funcitonality to pause macro?!
    ... For the pausing question it seems like Tim Zych's approach would be the way ... The problem is that the client at times may need to pause the ... I'm not sure how to pause the macro while it is processing. ... progressbar that is running. ...
    (microsoft.public.excel.programming)
  • Re: Funcitonality to pause macro?!
    ... thousans of records and can go for awhile. ... The problem is that the client at times may need to pause the processing ... I'm not sure how to pause the macro while it is processing. ... the progressbar ...
    (microsoft.public.excel.programming)
  • RE: Funcitonality to pause macro?!
    ... The problem is that the client at times may need to pause the processing for ... He has asked me to create the functionality to pause the macro? ... I'm not sure how to pause the macro while it is processing. ... the progressbar ...
    (microsoft.public.excel.programming)