Search For string in TextBoxes

[jquintana83]

Hello,

I am trying to loop through a group of TextBoxes. If the TextBox contains the string "FAIL" in it then the next line of code should execute. But I seem to be doing something wrong . I figured that I could use an array to accomplish this. Below is what I have so far...

Thank you!

Please Login or Register  to view this content.

[mikerickson]

Why not read the values directly into the strTxtArray

Please Login or Register  to view this content.

The arguments in InStr are in the wrong order. Also, InStr is case sensitive, that might also throw some things off

Please Login or Register  to view this content.

[jquintana83]

Hey Mikerickson,

The only problem I worry about is I have about 50 more other Textboxes that I don't want to loop thru'. By using the generic "TextBox" in the code wont it loop thru' everything when using the below?

Please Login or Register  to view this content.

[jquintana83]

I am doing something wrong because I'm getting a subscript out of range error.

Please Login or Register  to view this content.

[protonLeah]

Notice that the line: If InStr(1, strTextArray(i), "FAIL") <> 0 Then
is outside of the For..Next loop, so the the value of i is 22 and the array has no element 22. The Next i should be after the line Msgbox...

[jquintana83]

<---shaking my head in embarrassment...

Sorry, really long night while I juggle one project from another.

Thank you!

[mikerickson]

You can do this with a single loop. Eve

Please Login or Register  to view this content.