i'm confuse..

1st choice will be release if the value is not equal to the textbox AND the value in column B is equal to the label.caption

2nd choice will be release if the value is equal to the textbox AND the value in column B is equal to the label.caption

the code below is satisfy with the above statement..
[VBA]
Dim rs As Range
'the first choice
With Sheets(1)
For Each rs In Sheets(1).Range("a1", .Range("a" & Rows.Count).End(xlUp))
If rs.Value <> TextBox1.Text And rs.Offset(0, 1).Value = Label1.Caption Then
MsgBox "1st choice - No" & Chr(13) & rs.Value & " <> " & TextBox1.Text & Chr(13) & "Row " & rs.Row
'Exit Sub


Else
MsgBox "2nd choice - Yes" & Chr(13) & rs.Value & " <> " & TextBox1.Text & Chr(13) & "Row " & rs.Row
End If

Next rs
End With
[/VBA]