I've been reading all relevant posts but haven't found a complete solution.
Can someone help me take a value from an input box and use it locate a record?
On my "Menu" sheet, the user will click a button which opens the input box and asks them enter a record number (format = PCAR.yy.nnn.xxxx)
The records are stored on a "Log" sheet and the lookup value is located in column "F".
I found code on another post which I used to create the input box, but don't know how to take this input and use it to find the relevant record.
I have the following code, which I use to find the first empty row in which to add a new record. Any help will be appreciated. Would also be helpful if there is an error (record not found) to return to the input box to reenter the number.
Sub GetPCAR() Dim Pcarnum Pcarnum = InputBox("Please enter the PCAR number") MsgBox ("Searching PCAR") & Pcarnum End Sub Sub AddPCAR() Dim rNextCl As Range Set rNextCl = Worksheets("PCAR Log").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) Worksheets("PCAR Log").Activate rNextCl.Select ActiveWindow.DisplayHeadings = False End Sub