Respected members;
I currently have a code which enables me to retrieve data from sheet1 based on value in combo box rec2 ;
However I am looking for a way that will enable me to fetch values based on one additional criteria ie if column A or Range("A:A") to contains text "NEW"


Sheet1.Select
Chk = Application.Match(rec2, Range("B:B"), 0)
If Not IsError(Chk) Then
    For i = 2 To 13
        Me.Controls("rec" & i) = Cells(Chk, i)
    Next i
End If
Basically two criteria
!."NEW
2. rec2.value


Thanks for reading