Modal application VBA

Question

Dear All,

I have built an application by VBA Excel and created the .xlsm file.

When the xlsm file gets opened a login form appears but If I close this form I'm not able to open any other excel files because the behavior is like a modal form:

Could someone help me to solve/understand the issue?

Thanks

Answer 1

The issue seems to be this code:

No.

The problem is that your concept did not work at all. Make a new file and call a form as shown below.

Andreas.

Sub Test()
UserForm1.Show False
On Error Resume Next
With UserForm1
'Wait till the form is on screen
Do While Not .Visible
DoEvents
Loop
'Wait while the form is open
Do While .Visible
DoEvents
Loop
End With
End Sub

Answer 2

We need to see your file or a sample file that shows the same behaviour.

Upload it to an online file hoster of your choice and post the download link here.

Andreas.

Please see the sample file here

The issue seems to be this code:

Private Sub UserForm_Activate() 

    TimerStart Me.txtCountdown, Me, Me, Me.txtCountdown 

    DoEvents 

End Sub

Thanks

Answer 3

I found the issue.

It seems when I close my userform by this code

    Me.Hide 

    Unload Me

the application is still running:

or the menu gets disabled:

and I have to enable the Design Mode:

I really don't understand

Thanks

Answer 4

We need to see your file or a sample file that shows the same behaviour.

Upload it to an online file hoster of your choice and post the download link here.

Andreas.