Excel Search userform

[netizen1]

I hope this is a simple question since that will make it easy for me to understand. I have a worksheet that an person enters data into for each part number he works on. I would like to create a userform to search for the most recent date for the last time that part number was worked on. The results would show him the previous parameters for that part number.

So I guess I am asking for a double search first search for a part number coulumn D, then the most recent date for that part number in column A and return the data from that row which consists of ten coulums. I would like the data to be returned in a message box.

Thank you in advance for the help.

 

[Colin Legg]

You could do this with a formula in the worksheet if that's of any interest to you? Can you post a screenshot of some example data (we'll need to see this whether you go for the formula approach or for the userform approach)?

 

[netizen1]

I think I could figure out how to do this with just using the find but I would really like to do it with a userform. I have a little experience with userform as I am trying to teach myself by copying snipets of code from various websites. Here is a sample of the worksheet I am working with as requested.