Hi!
I'm not new to VBA but I'm not as good as I would like. I want to develop an excel application for an inventory and searching the web for help I found something similar on this forum here:

Inventory help ver 1a.xls
http://www.excelforum.com/excel-prog...ro-needed.html

Although this is a great work, I would like to change the userform but the code in there is over my current skills, unfortunately.

What I have is a list with products that can have multiple locations. I also have the quantity field. I don't know if this is possible, but I would like to change the location to a combobox where, based on the value in on the textbox product, to list all possible locations. Also, I would be good if below the combobox a text will specify in how many location my product can be found. I want to allow users to add the product but also, if they choose a previous location for the product, to be able to edit quantities.

I already search the web and tried some things but nothing works and I'm not even close to what I want.
I'm willing to learn but I really need some advice or help.


-