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.
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
What am I doing wrong?