I have this vba code and i want it to carry on finding the next cell with the same value, so every time i click the button it'll find the next cell with the same value. E.g. i type in mark it'll find the first Mark, then click again it'll find the second Mark and so on
Code
Sub Find_cust()
If Range("N3").Value = "" Then
MsgBox "Please enter a customer name"
Exit Sub
End If
valueToLookFor = Range("N3").Value
Set found = Worksheets("CD").Range("b:b").Find(valueToLookFor, LookIn:=xlValues)
If Not found Is Nothing Then
iRow = found.Row
Cells(iRow, "A").Select
End If
End Sub
Display More