userform make Excel freezes and restarts

[timecop79]

Can you please translate the following text into English:
"I am working on a small application in Excel that contains several userforms. When double-clicking on a listbox in the main userform, it opens a second userform that allows modification of the selected row. So far, everything is fine. However, after confirming to return to the initial userform, Excel freezes and sometimes restarts. If anyone can help me, please."

my file :

FICHE_V5_TST1.xlsm

Shared with Dropbox

www.dropbox.com

 

[Jimmypop]

Hi there...

Although I do not understand the language I did try something...please see if it will work for you...

at

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

try changing

Modifrm.Show

to

Modifrm.Show vbModeless

 

[timecop79]

Hi there...

Although I do not understand the language I did try something...please see if it will work for you...

at

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

try changing

Modifrm.Show

to

Modifrm.Show vbModeless

Thank you for the answer, I can explain more if you need

 

[Jimmypop]

Is it still doing the freezing... I tested and it froze on my side as well...after doing suggestion it did not freeze anymore.

 

[timecop79]

Is it still doing the freezing... I tested and it froze on my side as well...after doing suggestion it did not freeze anymore.

ok i will test and giveyou ansewr thanks

 

[timecop79]

Is it still doing the freezing... I tested and it froze on my side as well...after doing suggestion it did not freeze anymore.

it's working ,thanks now cany tell what was the issue

 

[Jimmypop]

Not sure what the issue could have been... might be something in the calling of the userform somewhere... glad it is fixed now...