Select, Edit, Add & Delete items in a list box

[baisty182]

Hi All!

I have a listbox with three columns, I then have 2 text box and 1 combo box underneath.
and then three commands, Edit, Add and Delete.
I've worked out the code to make the textbox and combobox fill when i click on the name in the list box but I cannot get them to edit.

I also want to type an entry into the text boxes to add to the list

and delete a name in the list....

this is my code so far!!

Please Login or Register  to view this content.

thanks!!!!!!

[royUK]

You need to really edit the cells, then update the ListBox

See the Databaseform example

[snb]

Did you consider using the built-in dataform ? (menu Bar/ Data/ dataform..)
in VBA:

Please Login or Register  to view this content.