Charging a listBox from value selected other ListBox and dynamic populate

Hi everyone

I'm starting with vba early and I don't know mucho more for now. I'm trying to put some value of a range at column A that have variable size and show into ListBox2 the values are at his row (also variable size).

for exaxmple If I selected value from a2 at ListBox1 show at Listbox2 values from B2 until column2 that have values (in this case C2). If select A3 show B3 until C3 ....

Also I want to do this with arrays and give the posibiliti to update this values (remove, adding or modify). I think this must be make it with cycles for or something and property ListBox Selected but I don't achieve the solution. Any help will or sugest how can read will be fantastic

I upload a test file I beguinin with, it is por and badly and I know it have lot of mistakes (names given to the arrays) etc. I'm working in it.

Note : for mistake I put this message here and it wa intended to be at VBa forum thread. Anyone can move it?

Sorry I'm late to answer but i went out yesterday. I revised the file (many thanks) but it continues to have a mistake, if you have only one ítem at the row.

I make some changes at your design but i can't get the solution. Hope you can ssay me what i've benn doing worng.

I upload my file in order you can see my proposal, I Split the data onto two sheets to make easiest the references and the actualization.

Also I need it advice you if you delete some value that is in use at the database, and warning you saying you must delete all the values before delete the ítem.

Thank you in advance for any help you can provide.