VBA lookup value in combo box, to populate value in textbox

Hello, first time posting here

I am very new to using the VBA feature in excel, and I need some help creating a user form on the attached spread sheet.

I work at a manufacturing facility and over the past 6 months or so i have been working with our plant manager (who is not computer-literate) on creating a current equipment list (Sheet 2), and also starting a preventive maintenance program.

As for my question - i have set up a user form where one selects the machine number from a drop down menu in combo box. What I would like to have happen is that when the machine number is selected from the combobox, three textboxes fill with the corresponding data from the table on the machine list tab: Machine Description, Model #, Serial #.

Eventually each machine will have a what i am calling a "PM Log" which will have the history of the work done to that machine. My over all goal is to have the master sheet set up so that using the user form, one can select the machine and the data for that machine will be displayed.

But if I can just get the user form to work I would greatly appreciate it!

Well, I can say that I do like this set up. THis way, I don't have to have multiple workbooks for each machine. I do have a few suggestions though.

I have re-attached the workbook you sent. I have attached comments to the areas i need changed, I would like to the machine # on the history tab to be the first column.

But I like the format you have set up. Thank you for your help.

Just a couple of things I noticed,

one of them is that things sometimes seem to drop off the machine history list, when adding items and refreshing?

Also, I was thinking about renaming the Report Tab to "Data Input", and have a third tab that one could use to look up the history of a particular machine, without haveing to do the filter. What I think might be best is that this third tab could also be a separate workbook.

Again, thanks for the help.