User controlled cancel in a vba loop

[mmogul]

I have a long running process (a Do Loop). I would like the user to be able to gracefully stop the process by clicking a cancel button or pressing an escape key.

I believe I need to use DoEvents, but I could use some examples as a guide.

thanks.

 

[bubba100]

take a look at the Sendkeys in the help

 

[mmogul]

Thanks.

I also just found this.

http://www.mvps.org/access/api/api0030.htm