I have a workbook that contains inventory items across 5 sheets. Each sheet contains the stock number, model, serial number, and description of each item. I have created a user form that a user can input the stock number in a blank "TxtBox" and a command button that says "Submit". How can i write the code so that it deletes the whole row (stock number, model, serial, desc) with a confirmation that it has been done? I have searched high and low and haven't come up with a solution to this yet. Thank you in advance.