Userform Run-time error 1004

Dear mr / mrs,

I get run-time error 1004 when I try to delete data with cmdDelete see below the VBA

Rowsource listbox1 = information

please help me to resolve this issue
thank you in advance for your support

Kirana

Please Login or Register  to view this content.

It has to do with this line

Please Login or Register  to view this content.

in the "ListBox1_Click" macro. If I comment out this line, it works fine.
The error states that an application or object hasn't been defined

More info: I stepped through the code and noticed that when the delete code runs, after it does this line....

Please Login or Register  to view this content.

it runs back through the ListBox1_Click code. At this point the range you want to activate has already been activated so it errors??

As gmr4evr1 above, and and additionally:
1. After deleting a row, 'ListBox1_Click' procedure runs 2x/works twice and fills the text boxes
2. Why, since after returning, to the 'cmdDelete_Click' procedure, text boxes are clearing ?
3. You haven't 'UserForm_Initialize' procedure
According to me, you should add 'UserForm_Initialize' and improve the triggering of procedures (to prevent multiple runs).
You could add e.g.:

Please Login or Register  to view this content.

and modify 'cmdDelete_Click', e.g.:

Please Login or Register  to view this content.

gmr4evr1 is right.

In this type of scenario

I Declare a public ChangeFlag as Boolean

I then set ChangeFlag as True before I perform a function that could create an error

I then set this back to False when I know that the risk of error has passed.

This code works:-

Please Login or Register  to view this content.