Populate combobox based on text value in userform

[namuser]

Hi
I have a table with 3 columns: Products, Location and Quantity. I created a userform to add new products and the code runs fine. Still, I would like my userform to do the following:

-if someone tries to add a product and that product exist in different location, I would like to view those location in a combobox (?not sure, never used one). Under the combobox I would like to list number of locations ( like a text: Your products is listed in 3 other location). If I don't choose a location, the user can add a new one but if another location is chosen, a textfield called Quantity will be populated.

I hope this can be done, I searched the web but I didn't find anything similar to this. I don't even know if I should use a combobox for what I need.
I do hope someone can help me with an advice, a link or some code to get my started....

Thank you!

 

[Norie]

How is the user adding a product and what/where are they adding it to?

 

[namuser]

in my initial work, the user added a product via userform to first empty cell in the table (sheet1). The userform had 3 textboxes: product name (unique), location (same unique item can be in different locations) and quantity.
My first intention was to create another userform only with a textbox for product name, and a search button. Pressing search would have populated another sheet (called locations) with all the locations and quantity where you can find that specific item.

But I would really like to be able to add products but also edit quantities for all product's locations (add and substract).
I'm realizing that doing this is not a simple task (at least for me) but I would like to know if this can be done...