Userform doesnt work suddenly

[jasonxlui]

The situation is that I have a userform1 namely "accounts". Within it, I have a button"A" to trigger another userform2 namely "account selection".
In the userform2, I have the "accountok" button to trigger the following code. Previously, when I click the "accountok", I will only unload my userform2. But under the
situation I didnt change the code, some problems happen. When I am opening the Visual Basic Window, I click the "accountok" button, it will directly close my second and first userform at the same time(i.e
close all things). But if I close the Visual Basic Window, the code functions properly. (Although I dont think it is related to my code below) Anyone can help? Please

Please Login or Register  to view this content.

[torachan]

see big yellow banner - upload your workbook

[jasonxlui]

Now uploaded my excel file. I repeat my problems again.
Now, when I am opening the Visual Basic window, I click the "Placing Orders" button → click the "select" button" → Randomly click any account and then click "OK"
it will close all my userforms.

But if I close my Visual Basic window and then perform the same actions, my first userform still remains here and only the second userform will be closed.
Thank you all.

[HaHoBe]

Hi jasonxlui,

you would need to include an information about having posted the same request at least at one other forum https://www.mrexcel.com/board/thread...denly.1183546/. As I´m not so sure that you can do so I´ve added this link.

And maybe even edit the opening post and wrap the code with code-tags?

[jasonxlui]

Yes, i cant add the link, even quoting your reply including the link.
Besides, I added the code tag, thanks.

[AliGW]

@jasonxlui

It would appear from the TWO mistakes you have made already that you need to read this forum's simple rules. Please do this BEFORE posting again.

Here is a direct link to them for your benefit: https://www.excelforum.com/forum-rul...rum-rules.html

Thank you.

[torachan]

@jasonxlui, I can not replicate your described error -

[jasonxlui]

I can not replicate your described error -

Sorry, dont know why no error in this file. I reuploaded a new one. Many thanks.

[jasonxlui]

I will follow the rule next time. Sorry and thanks.

[Artik]

In the Accountform Properties, set ShowModal to True

Artik

[jasonxlui]

Sorry, it is not the error I mean and I want to remain the Showmodal to be false.

[torachan]

Sorry, it is not the error I mean and I want to remain the Showmodal to be false.

Why ?????????

[jasonxlui]

Why ?????????

That sentence is used to reply artik.

My error still here.

Situation1:
when I am opening the Visual Basic window, I click the "Placing Orders" button → click the "select" button" → Randomly click any account and then click "OK"
it will close all my userforms.

Situation2:
If I am not opening the Visual Basic window, I click the "Placing Orders" button → click the "select" button" → Randomly click any account and then click "OK"
it will not close my userform namely "Placing Orders" in the top left corner. (And I want to remain it open)

So, I think it is not related to the showmodal, right? (I remember previously I also set the show modal to be "False", my "Placing Orders" still will not be closed even I am doing the things situation 1 .

[Artik]

jasonxlui, did you do what I said (ShowModal = True)?
If not, then do it. Then run the form, choose something from the accountselection window. Has the accountform disappeared? He stayed open with me. After this test, I re-set ShowModal = False in the accountform. From now on, your problem does not occur, whether the VBE is open or not.

There seems to be some garbage in the project that was interfering with proper operation.

Artik

[jasonxlui]

jasonxlui, did you do what I said (ShowModal = True)?
If not, then do it. Then run the form, choose something from the accountselection window. Has the accountform disappeared? He stayed open with me. After this test, I re-set ShowModal = False in the accountform. From now on, your problem does not occur, whether the VBE is open or not.

There seems to be some garbage in the project that was interfering with proper operation.

Artik

yes, did it but didnt know repeat one more time can make it normal.
Now it is solved. Many thinks!!