VBA code to find the value of cells

[Akw47]

Hi currently I have this code

Private Sub TextBox1_Change()
    Dim c As Range
    If Len(TextBox1.Value) >= 5 Then
            If c in ThisWorkbook.ActiveSheet.Range("D1", .Cells(.rows.Count, "D").End(x1Up)) Then
             If InStr(c, "/") > 0 Or InStr(c, ",") > 0 Then
                    If MsgBox("Please confirm cell " & c.Address, vbYesNo, "Double Check") = vbNo Then Exit Sub
            End If
        End If
    End If
End Sub

But there is a error at the "if c in thisworkbook" statement. I want MsgBox to pop out when my the 5 digit number in textbox1 match with the same number in column D with a "/" or "," with it

 

[GWteB]

@Akw47, you are starting multiple threads with the same issue providing code from others that's changed in a way it shouldn't, causing you errors.
This approach is almost like cross posting and makes it unattractive for others (at least for me) to lend a helping hand ...

Message Box after a condition is met

Hello so this is the code I currently have Private Sub TextBox1_Change() With ThisWorkbook.ActiveSheet With .Range("D1", .Cells(.rows.Count, "D").End(xlUp)) If InStr(UCase(Me.TextBox1.Value), "/" Or ",") > 0 Then MsgBox("Please confirm", vbYesNo, "Double Check") =...

www.mrexcel.com

 

[Akw47]

@Akw47, you are starting multiple threads with the same issue providing code from others that's changed in a way it shouldn't, causing you errors.
This approach is almost like cross posting and makes it unattractive for others (at least for me) to lend a helping hand ...

Message Box after a condition is met

Hello so this is the code I currently have Private Sub TextBox1_Change() With ThisWorkbook.ActiveSheet With .Range("D1", .Cells(.rows.Count, "D").End(xlUp)) If InStr(UCase(Me.TextBox1.Value), "/" Or ",") > 0 Then MsgBox("Please confirm", vbYesNo, "Double Check") =...

www.mrexcel.com

GWteB I am so sorry for this but how do I go about it, next time when I try to adjust the code myself and gets stuck with a problem. Please advise. I really didn't mean to cross post or get you offended I am sorry

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.