Add, Edit, Delete items in dynamic listbox

Hello.
I've written in the subject of thread "dynamic listbox".
I don't know if it is correct but you'll understand what I mean opening the test file from the attachment.

I have two questions:
- could it be written a code able to create dynamic ranges for the columns from sheet "Liste"? (number of rows in column is variable) I have a code that create the ranges but only with the same lenght with TipDoc range (please see the module CreateDinamicRange).
- in the "2" section of the userform there are three options: Add, Edit and Delete. Each of this command buttons must Add, Edit or Delete the selected item in the list lstCodDoc. Can it be done?

I have a code for the Add New Entry command button but it doesn't work in this case because I don't know how the range could be changed.

Please Login or Register  to view this content.

Thank you.

So you want to be able to modify the selected listbox by either removing or addin items.
Does Edit work?

Two things to change:

Modify the code in the userform for this macro

Please Login or Register  to view this content.

And add place this function in any of the VBA modules;

Please Login or Register  to view this content.

To Edit and to delete I did not do anything but with this you can probably build it in

Create Columns is necessary to 'refresh the data and make sure it's registered.
The second code is to identify the column that you are modifying.

OK.

I added a line in next code:

Please Login or Register  to view this content.

Does Edit work?

No, Edit doesn't work. Also Delete.
What do you think about?

I did not do anything with Edit and Delete.
I just gave you the code Add.
The part to Edit and Delete will have to be approached in another way.
Do you want me to write that for you too?

What does the code do that you added?

Yes I understand that, that is why the way you have set it up needs some minor modifications, I will place English text in the message boxes which you will have to translate to Romanian.

I hope you will not mind that I will change you code a little.

Okay, I did not make too many modifications.
I changed the userform where you had EDIT and DELETE
I also added conditional formatting to the "Liste" so if the cell is not empty you get a border
It all seems to work now as far as Add, Edit and Delete

If you have any questions, just post

You have the sample, try it, do you think you can, that is the best way to learn VBA.

Just add a routine to find the value in that column, if found the exit.

Okay, here is the code, I think I took care of all possibilities too, also when you edit it will check if the new value exists.
I added one function so you can use if you more than one situation, you just pass the column letter and the text to check