JP asked if I could expand on the Cancel post. I thought that I had already posted a DoEvent example, but I couldn’t find it on this blog, although when I dug out the org. file it did have a link to a blog post that didn’t work!!!! Maybe my blog is losing content!
Anyway here is an example file which shows what I mean:
MIE DoEvents Example 2008.xls
I get it. Adding DoEvents to your loop allows the Click event of the other button to occur. Thanks.
–JP