Change listbox value

Originally Posted by jaslake

Hi Stingone

I'm missing something in your explanation. I can fill all the TextBoxes with blanks and it updates as expected and no error is reported.
Please explain again.

If you open the excel file and the userform disapears when clicking directly on the modify button without selecting a row it gives an 1004 error.