Anyone know a loop for this?

[calvinle]

Hi I want to know which will be the best way to loop this:

Step1:
For x to y
IF FOUND
GoTo Step2
If NOT FOUND
GoTo Step1 'redo for the next loop
If THIS
Goto EXIT

Step2:
For x to y
IF FOUND
GoTo Step3
If NOT FOUND
GoTo Step2 'redo for the next loop
If THIS
Goto EXIT

Step3:
For x to y
IF FOUND
GoTo Step4
If NOT FOUND
GoTo Step3 'redo for the next loop
If THIS
Goto EXIT

Step4: 'final step so go EXIT.
For x to y
IF FOUND
GoTo EXIT
If NOT FOUND
GoTo Step4 'redo for the next loop
If THIS
Goto EXIT

EXIT:
Redim...(blabla)
Exit Sub
Thanks.

[shg]

Please Login or Register  to view this content.

[AB33]

Plese use code tags with your code.
IMO, None of them!
If you have read Dummies book for programming by John, it is a terrible coding to use goto.

[Norie]

What are you actually looping through and what are you trying to find?

[calvinle]

I have 5 textbox on my userform. I need to validate if each box can be found on my external application.
The code between the IF is used by my application. It's a function.
The application will read the row 1 on the application, if it cant find, it will go to next row until row 9 (last row) of the screen. (Thats why the for x to y is used for)
If it can find, then step2 is the next inputbox to scan between those rows.
The exit door is in case it cannot find at all, it will stop the scan.

I dont know about ubound :/

[Norie]

You don't really need a loop for that.

Functions/code can be used to search for the values in the textboxes in the range, and if not found the sub can be exited.