>If strResult = "" Then Exit For
I wonder why you need to compare an Int16 to a string!
>if the response = 0 then carry on as if nothing has happened.
I am assuming you mean carry on executing the loop
>But if the response is more than 0 then I need it to show a messagebox to the user but move on to the next row.
Assuming this means show a message and still carry on the loop
Add following code inside loop
Main Topics
Browse All Topics





by: burningmacePosted on 2009-09-15 at 06:41:17ID: 25334750
If strResult = "" Then Exit For