joms
12-13-2010, 09:37 PM
Hi guys, need your help stuck with this.
I'm using excel 2007.
I had two forms, userform1 and userform2.
I had a button on userform1 to display userform2.
When i click on the button on userform1 to display userform2, it works fine.
But when i close userform2. Then click again on userform1 button to display userform2.
Userform2 will display, but the form will just display but i cannot close the form. It's like the form just freeze, i need to press ctrl break to exit.
Codes for displaying the two forms:
useform1 button:
userform2.show
Unload Me
code on userform2:
userform2_terminate
Unload me
userform1.show
why it's behaving like this, it's just hide and show of the forms. any ideas is greatly appreciated. Thanks. :think:
I'm using excel 2007.
I had two forms, userform1 and userform2.
I had a button on userform1 to display userform2.
When i click on the button on userform1 to display userform2, it works fine.
But when i close userform2. Then click again on userform1 button to display userform2.
Userform2 will display, but the form will just display but i cannot close the form. It's like the form just freeze, i need to press ctrl break to exit.
Codes for displaying the two forms:
useform1 button:
userform2.show
Unload Me
code on userform2:
userform2_terminate
Unload me
userform1.show
why it's behaving like this, it's just hide and show of the forms. any ideas is greatly appreciated. Thanks. :think: