Msgbox until a specific string is found.

[excelkeechak]

Hi,i had written a sample code in which a message box pops up until the cell reaches a specific string. i had attached the excel sheet. my loop is not running perfectly. Its going into infinite loop.

I want a message box appear till the value of the cell in the column (Range:d1:d20) is "Admin Incharge" using Do and For Loop.Kindly correct where my code went wrong.

[StephenR]

I won't ask why you're doing that...

Please Login or Register  to view this content.

[slx]

Please Login or Register  to view this content.

What happens here is ur looping without proceeding to the next range.

Please Login or Register  to view this content.

[royUK]

Loops can slow down code, looping a msgbox will take even longer. Why not use .Find to find the string?

[excelkeechak]

Thanks,Stephen and mr.Roy for Your Replies. Mr.Stephen Its my own idea and example just to learn Do Loops. I m just giving a try to it. I wanted to learn Do Loops so its just a small example of applying it.

As suggested, by mr.Roy. Yes its taking time to display the msgbox.I will try to implement .Findmethod in my Example.thanks Mr. Roy again for ur suggestion.also do tell me any examples of Trying n using Do Loops .