Could anyone help me with a procedure to display a timer in xls (e.g a count down)?

Also, could you please tell me what event method causes a macro to get executed upon starting a workbook? I want my macro to get executed without the user pushing any buttons.

Thank you in advance for your reply!


I was able to resolve the first question using the Timer parameter in VBA. I accomplished the count down with a loop procedure. I can post the procedure if anyone is interested. Does anyone know about my second question?


I found the answer to the second question as well. The code should go in MS excel objects, by clicking on the "this workbook" object and selecting the behavior (in my case "open") from the top code window.

Private Sub Workbook_Open()
Application.Run "'myxlsfile'!MyMacro"
End Sub

Thanks for those who read my original questions.


Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.