Help with Message Box Information

[DEllis]

I have a form that I put in a part number and hit a search button, I would like for the search result to be a message box that pops up and tells me that part number is on line # whatever (row), and if it is not in the database to say "Part number not found".

Is it possible to locate what row the part number is on and have a message tell me this?

THank you

 

[jbeaucaire]

Something like:

Sub Search_Click()
Dim PartNum As Range

    On Error Resume Next
    Set PartNum = Sheets("Parts").Range("A:A").Find(textBox_Part, LookIn:=xlValues, LookAt:=xlwhole)

    If PartNum Is Nothing Then
        MsgBox "Part number not found"
    Else
        MsgBox "Part number found on row #" & PartNum.Row
    End If

End Sub

 

[DEllis]

Thank you so much! My brain was just stumped....

Must be the curls or red hair...not sure which, but I appreciate your resolution.

Take care.
DEllis

 

[Joe4]

I see that this question is in the Access Forum, but the response is an Excel response.

So is this actually an Excel question that I should move to the Excel forum?