Hi All

I would like to know if it is possible to edit a list box directly?

I have a userform with a textbox to add items to a list box on the form. I want to make it possible for the user to select an item from the list and either directly edit it or for the item to be placed in the textbox for the user to edit. The actuall items in the list are stored in one of the sheets and I have defined a name for the range.

I set the value of the textbox = listbox1.value under the MouseDown event of the listbox. However, I can't think how to update the edited item back to the listbox. Basically I want to overwrite the old item with the new one.

I would appreciate any help.

Thanks

Kind Regards