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
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