Search then add information

[kapps813]

New to userforms.
Looking to add a function to a command button that will "Search" for an existing serial number listed in table1 (column D), then display combined values from two other cells (column B & C) into one locked textbox "Manufacturer/Model" for verification.
Using a second "Add" command button within the same userform, allow me to add/edit data in the same row as the found Serial Number into columns J (Date), K (Name), L (Address), M (Notes).

Thanks for the help

 

[EFANYoutube]

Should be as simple as:

For Each cell in ThisWorkbook.Sheets("Your Sheet Name").Range("D:D").Cells
        If cell = TxtNameOfYourSerialNumberTextbox then
                  Manufacturer/Model.text = cell.offset(,-2) & cell.offset(,-1)
                  Exit For
        End If
        If cell = "" then Exit For

I am doing this out of a user form as I don't want to create one but if you get an issues let me know