[RESOLVED] Excel Form

[JJJCR_FOX]

Hi need your help guys,

i got two forms on excel, userform1 and userform2.

When i click on userform1 button to display userform2, it works okay but when i close userform2 and click the button again to display userform2. The form will display but it will hang.
The form cannot be closed need to press cntrl break to exit.

any ideas is greatly appreciated..

[westconn1]

any ideas

if you show us some code, maybe we can figure what is happening
the procedure that opens form2 and the code within form 2, that may be relevant

[JJJCR_FOX]

Hi westconn, it's just a simple hide and show. i don't know why it's messing up.

userform1 button:
userform2.show
unload me

userform2_terminate event:
userform1.show
unload me

[westconn1]

probably should not have unload me in the terminate event as well as it is already unloading

[JJJCR_FOX]

hi westconn1, had tried taking out the unload me on the terminate event but makes no difference. the form still hang. any ideas?
thanks.

[westconn1]

does form1 unload after form2 unloads?

[JJJCR_FOX]

does form1 unload after form2 unloads?

first click on button of form1 to display form2. form1 will hide and form2 will display.

then close form2. form1 will display.

click again on button on form1 to display form2. form1 will hide and form2 will display.

tried closing form2, but will not close. Form2 hang.

this was the sequence of the problem.

But i was able to notice that when i place a code on form2 terminate event or either form2 activate the thing will hang.

so what i did i just make a code to disable the x button on the form and force the user to use the exit button on the form. problem solved.

but why is it, when placing a code on terminate or activate event will cause the hang?

thanks for your reply westconn

[westconn1]

as your code in the button was
show form2 then unload me
form1 should have unloaded when form2 was closed

why it didn't is a mystery to me