Excel Command Button Macro to ask for Part # and update another sheet with info

Hello

I am currently working on a with a list of vendor material item. The two sheets I have are the material log with all the parts available for rent and another sheet with the parts we currently have on site from the vendor. What I am trying to do is create a command button that will ask the user to input the part # it will then select the part # and part name from the material log ask the user to enter the daily cost and how much square footage is on site then enter the information on the next available line on the excel sheet of parts on site in the correct locations on the sheet.

This is the code i have so far:

Please Login or Register  to view this content.

I am not sure how to go further than this.

Could you post a copy of your file with a detailed description of what you would like to do? This would make it easier to follow.

Here is the doc. The description is in the doc.


20130208 Ulma Formwork Log.xlsx

Hi dka. Try the attached file. I've made a couple of minor changes to the first sheet. I had to remove the merged cell in A1. Merged cells most often cause problems for Excel and should be avoided if possible. Just double click on the part number and you will be prompted for the additional information. Let me know if this works for you.

Thank you Mumps1. This works perfectly. I really appreciate it'

It was my pleasure.

So I started messing with the code and the data. Add filters to the doc to make it easier to navigate. I also decided to input the Daily Cost and use the macro to pull that data into the other sheet as well. I thought it would be as easy as adding another cell for the range but I am getting a compile error.

Please Login or Register  to view this content.

Any ideas?

Try:

Please Login or Register  to view this content.

Thanks Mumps1. I ended up using Vlookup to solve the problem. It worked like a charm.

Glad you found a solution.