I have a COM application reading in real-time data into Columns A and B in Excel but i want it to stop when i press a command button, I have the code below but it comes up with an error on the Stop part.
What am i doing wrong? and how can i get it to stop?
Cheers

#########
Private Sub cmdStop_Click()
Dim I
For I = 1 To 10 ' Start For...Next loop.
Debug.Print I ' Print I to the Immediate window.
Stop ' Stop during each iteration.
Next I
End Sub
##########