First let me say thank you for any help, Novice here. I have a userform with a textbox that is auto populated with a value which is made up from two numbers from two different columns on the worksheet. The first number is the date stored as Microsoft reference (ie today 10/13/2021, 44482), a "-", and sequence number (01). It is stored in column C on the worksheet in the following format, "44482-01". I need to find out if that value exists in column C of the worksheet. Below is my feeble attempt to try and find a match. I get the response "Did not find it" every time the code runs, even when the value does exist in the column.
Code
Sub Find_Match()
Dim TB As String
TB = Me.TextBox1.Value
If Cells(Range("C2").End(xlUp).Row + 1, 1) = TB Then
MsgBox "Found It!"
Else
MsgBox "Did not find it"
End If
End Sub
Display More
What am I doing wrong?