Member Avatar for mason12345

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!

-m

  • 1 Contributor
  • 2 Replies
  • 70 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mason12345
Member Avatar for mason12345

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?

Thanks,
-m

Member Avatar for mason12345

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.

cheers,
-m

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.