Loop problem

[reggie1000]

Hello,

Davegugg solved my multiple search problem, very grateful to him, however, using the code for another userform I have, it has a problem with looping through the code, the code searches firstly by column C (via textbox1114) and then by Column H (via combobox 3) to find the corresponding matches against the two columns.

The problem is that when the strings that your searching for don't appear in the range it goes into a continious loop, so by searching for anything other than the strings from col C or H it should produce the MSG box for no entry but doesn't.

Please Login or Register  to view this content.

Any ideas would be appreciated.

thanks reg

[tigeravatar]

reg,

Updated code:

Please Login or Register  to view this content.