Thread: Search and find
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick K Rick K is offline
external usenet poster
 
Posts: 1
Default Search and find

Need help on creating a routine that loops down through a
spreadsheet's rows that contain entries and compares the
entry in column 1 (State abrevation) with column 2 entry
(shipment method). Specificly I want to return a msgbox to
the user when the state = "HI" or "AK" and the ship method
is "ground", and then quits the vba form so the user can
correct the situation.
Thnaks