VBA - Excel crashes after ca 102 userform show/unload cycles

[sejrik]

Hi,
i have problem with excel form.
If I show Userform, then unload it and show it over and over again, i get error message.
It's visible in attached example.


After click on start, excel will show and unload form over and over.
After count reaches ca. 102 (<2 min.), excel crash.


It's possible resolve this crash and count until user stop it without using ShowModal = False?


(This is only example. I don't count number, I only need show forms over and over without crash.)


Example and error screenshot is in link below.
https://drive.google.com/folderview?id=0ByJeH3S65yLWNFgzQ1lUUVR0OXM&usp=sharing

 

[skorpionkz]

EDIT: ignore didn't help

 

[skorpionkz]

I managed to have no crash, but for some reason the "quite" variable, doesn't change value to "true" after quite is pressed. Check this maybe you will able to fix it

https://www.dropbox.com/s/6pofbozgjfawt94/AutoUpdated Userform Crash.xlsm

 

[sejrik]

Thank You.
Your code work.


But i have another example, where i got the same error as in my first example.
I uploaded it here.


Run example2.xlsm, click on button and hold enter, until form stop responding. Then if You close non-responsive form, get the same error as in example1.
Can You help me with this?

 

[skorpionkz]

are all 3 userform different? why can't you use 1 and just run it over and over again in same principle as first example?
Just can't see the point of pressing "enter" 100 time on userform.

 

[sejrik]

This is just example.
I need insert 3 differents data in 3 (visualy) different forms.

 

[skorpionkz]

with so many repetitions? It stopped for me when i pressed Enter 190 times A bit changed code

https://www.dropbox.com/s/tiskx41lccie11r/AutoUpdated Userform Crash 2.xlsm

 

[skorpionkz]

I think this is working now. please check above link (I updated file).

 

[sejrik]

Thanks.
This look good.