---

How can i jump out a loop when a button is clicked?

---

..... Exit For
..... Exit Wend
..... Exit Do.... Depending on the loop type
"Danny Mertens" <dmertens@home.nl> wrote in message
news:NhGZ6.133118$y7.1054380@dbsch1.home.nl...
> How can i jump out a loop when a button is clicked?
>
>

---

Danny Mertens <dmertens@home.nl> wrote in message
news:NhGZ6.133118$y7.1054380@dbsch1.home.nl...
> How can i jump out a loop when a button is clicked?
>
Hi Danny

You can use one of following:

Exit Do
or
Exit For

Depending on which kind of loop it is.
--
Mvh.
Mikkel Bundgaard
RUC Datalogi
http://officehelp.gone.dk

---

thx but the problem is i cant push the cancel button while being in loop ?
I can only push it while ready with loop

"Danny Mertens" <dmertens@home.nl> schreef in bericht
news:NhGZ6.133118$y7.1054380@dbsch1.home.nl...
> How can i jump out a loop when a button is clicked?
>
>

---

In that case you must insert
DoEvents
in your loop, which stops VB and checks for events like mouse, keyboard,
window move and alike.

DoEvents can be very slow so perhaps you should only use it for every 10th
run through your loop...


"Danny Mertens" <dmertens@home.nl> wrote in message
news:_Vg_6.144849$y7.1153985@dbsch1.home.nl...
> thx but the problem is i cant push the cancel button while being in loop ?
> I can only push it while ready with loop
>
> "Danny Mertens" <dmertens@home.nl> schreef in bericht
> news:NhGZ6.133118$y7.1054380@dbsch1.home.nl...
> > How can i jump out a loop when a button is clicked?
> >
> >
>
>