I am trying to get a text box to look at a range of values to determine if what is entered into the text box matches one fo the values in the range of cells. Using the following code I get a type mismatch error message:
Private Sub TextBox1_Change()
If TextBox1.Value = Sheet1.Range("A1:A3") Then
TextBox1.Value = ""
Exit Sub
End If
If I change ("A1:A3") to ("A1") it will work...
Bookmarks