Hello everyone,
My manager is looking for a small database and is requesting it to be done in excel. Why I do not know but, How can I query info on another sheet, sheet 2, in the same work book by using a text box and a command button on sheet 1? In other words when I type a part number in textbox 1 and click the command button I'm looking for textbox 2,3,4,5,6,7,8,and 9 on sheet 1, to retrieve the data from sheet 2, from the column that has the same data as textbox 1. Textbox1 will need to query only data from column A of sheet 2, but fill all other textboxes with the information from the cells to the right.

Now since I've confused everyone this Wednesday morning I hope you can help.