Timer in userform, userform set ShowModal property false

[Wijnand1]

Good morning all,

I have the following code in a user form to start, stop and reset a timer.

the ShowModal property of userform1 must be set to False in IDE, otherwise the timer doesn't work. Is there a way to make the code so that the property of userform1 cab be set to True in IDE ? I need this so it will work with other user forms.

Hope someone can help .

Please Login or Register  to view this content.

The following code is in Module1.

Please Login or Register  to view this content.

[Wijnand1]

Hope someone can help, I searched the internet but found no solution so far.

[Logit]

"Is there a way to make the code so that the property of userform1 cab be set to True in IDE ? I need this so it will work with other user forms."

Not certain that is very clear.

If you mean being able to work with other things while the Timer Form is visible and running, the the "SHOW MODAL" property would need to be set to False.

????

[Wijnand1]

Hi Logit, the "SHOW MODAL" property of userform1 needs to be on True, now it is on False. The problem is when I set the "SHOW MODAL" property of userform1 True the Public Sub TimeLoop doesn't work. There is no countdown in label1.

[Andy Pope]

If you use a object to reference the userform you can show MODAL and update contents with timer.

If you modify the module code in Logit's example,

Please Login or Register  to view this content.

The form is modal and timer works.

I think the real issue is the userforms state when the other user forms are displayed. Once set to MODAL you can only show other modal userforms, you can not mix form states