Userform search and edit function help

NOOB here (soon to be bald because I'm pulling my hair out trying to make this work), Thank You in advance for any help you can give me.

I made a userform that populates cells in excel using various code from "real coders" like you guys lol. The function of this userform is to create an item list for insurance adjusters to be able to type the item, qty, price, and store bought from and behind the scenes on another worksheet it will populate each item on new lines as you hit the "add item" button. This userform also calculates tax and depreciation based on calculations that I placed in the cells in the worksheet (it would be really nice if the VBA code could add these calculations as you add each item but I would have no idea how to begin on doing that).

The problem I'm having is I need this to be more user friendly...

I need to create an identical userform but with a "search" button and an "Update Item" button. When you type in any of the form fields it will retrieve all matching items that have the same data typed in that specific field when you hit the search button. Once you find the item you can change the item information and press "update item" and it will overwrite that line in excel to the new data.

As I stated earlier I would also like the code to be able to insert the calculations as it adds the line each time you press add item, currently I have it calculating in excel as I don't know VBA very well to make this happen.

If you want to email me you can at adjustermn at gmail dot com.

I also posted the same question at another forum (sorry didn't know I was breaking any rules) please visit http://www.mrexcel.com/forum/showthread.php?t=446939 to see what they might have solved with this.

I attached the userform for you to see what I'm talking about in my rambling above.

Thank you
Mark

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.