Hi there, I'm getting an 'Object Variable or With Block Variable Not Set' error message when my find command runs. This is after a user enters a value like '0092' in my find text box on my user form. Other numbers entered that don't begin with 00 are fine.

Basically what I'm trying to achieve is to have the user type in a number or text in textbox TB9 and in the TB9_change sub, have the find command search a range in one column and return a value in offset (0, 2).

My code is :

If Application.CountIf(Worksheets("Paste Artwork Matrix").Range("G1:G10000"), TB9.Value) > 0 Then
        TB10.Value = Worksheets("Paste Artwork Matrix").Range("G1:G10000").Find(What:=TB9.Value, After:=Range("G1"), LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Offset(0, 2).Value
        TB10.Visible = True
        TB10Label.Visible = True
End If
Could anyone please advise what's going wrong...and how I can get it to search for cells with 0092 in them?