excel - How to loop through all the rows in a column -

i trying loop through every row in column b , string "no" in each row.

the pseudo code follows :

loop every row in column b

 if "no" in row within column b   display , alert box "unpaid" 

end loop

this code needs in vba, appreciated.

i suspect not want, how can loop on rows in column. loop every row in column. in excel 2003 65536 rows, , in 2007+ 1048576 rows, painfully slow execute. can of course modify work on used range in column, if need.

also, msgbox not give opportunity edit sheet, nor give information cell(s) affected. need modify code actions, if needed.

sub test() dim col range: set col = range("b:b") dim r range  each r in col.rows     if r = "no" msgbox "unpaid", vbinformation next  end sub