How to stop looping in windows 7

Hello Friends,

i am making a loop around 50000 to extract the data

if suppose i want to stop the loop (to check the loop counter) in between process then how to do it.
because in XP, if i press escape button then loop stop and i can check how much data extract till then again i press F5 to start

but in windows 7 if i press escape button while in loop the it says not responding and i have to close this window from task manager.

Please suggest
if i want to check how much counter goes in loop then how to check?

I suspect you falling in to infinite loop. This could only happen if you are using a while loop. For a loop always end when the loop ends. You can also stop For loop before the end of the loop. Let's say you have.
Option Explicit

Please Login or Register  to view this content.

This code loops from row 2 until the end of none empty data in column A.
You can also use this line.
For i = 2 To 500
The code can either go all the way to 500, but can also terminates when it reaches 100 if you include if statement.
If i = 100 Then Exit For