Hi guys,

This seems a bit complicated, but I hope someone can help me. I figure out a way to organise my data which is to use Define Name. Because my data is 2 columns, 1st column is ID of the product, and 2nd colunm is the price to it. And these items are associated to an ID # which is the Define Name.

I have multiple request in here.

1) I want to be able to display the rowsource in the listbox1 from the choice made from combobox1.

2) If the inventory has been changed, then the user can choose to edit that ID#. In that edit mode, the user can choose to edit directly from the listbox (if possible because it's faster), or have to edit 1 by 1 with a textbox example. Also, if the user decide to add more ID product, it will be added to the next data of the same define name.

3) If the ID# is not available in the inventory, then the user can choose to add new inventory. This will add a new define name and a new data will be be store to the next available rows in the spreadsheet.

Finally, the spreadsheet is used to store the data, so I don't want the user with less knowledge to manipulate the whole inventory. That is why I prefer them to use the userform instead, more friendly.

Here is the template of the userform to start with:
listbox_sample.xlsm

Please help anyone.

Thank you.!!