View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
miao jie miao jie is offline
external usenet poster
 
Posts: 14
Default how to stop program in a big loop?

Hi, everyone
Right now I wanna do a time-comsuming loop in excel programming, for
example:

for i = 0 to 100000
for j = 0 to 10000
'my parts
doEevents
next
next

during run time, I still wanna use a "Cancel" button to let user have choice
to stop it during run time? how to do it, Pls advice