Runtime error 400

[kelly mort]

I just woke up to face this problem .

I have been doing my best to fix it since but I am not able to.

When I call my userform I get run time error 400

Form already displayed; can't show modally.




I have tried restarting several times but the form seems to load twice each time.

Now I am getting stacked. Can someone point out my error ?

Regards

 

[Joe4]

Can someone point out my error ?

Probably not without seeing all of your VBA code.
Be sure to check ALL VBA modules. Perhaps you have some code running automatically in the ThisWorkbook or one of the Sheet modules.

Have you tried stepping through your VBA code to see what it is doing, and if it is trying to open the same form twice?

 

[kelly mort]

Probably not without seeing all of your VBA code.
Be sure to check ALL VBA modules. Perhaps you have some code running automatically in the ThisWorkbook or one of the Sheet modules.

Have you tried stepping through your VBA code to see what it is doing, and if it is trying to open the same form twice?

I am still inspecting the codes but what I don't get clear is that even when I run it from the vb editor still it shows that error.


I will step through as you said and see.


Edit ::


When you say automatically do you mean those that call the form or any code at all?

 

[Joe4]

I am referring to Event Procedure code, which runs automatically upon some event happening (as opposed to being called deliberately, either by manually, from a button, from a keyboard shortcut, etc).
See: http://www.cpearson.com/excel/Events.aspx

 

[kelly mort]

I am referring to Event Procedure code, which runs automatically upon some event happening (as opposed to being called deliberately, either by manually, from a button, from a keyboard shortcut, etc).
See: http://www.cpearson.com/excel/Events.aspx

This link was very useful.

I just found out there are series of conflicts in my scripts so I am fixing them and the issue too seems to be varnishing gradually.

 

[Joe4]

Excellent! Glad to hear it.