•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 397,818 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,611 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 836 | Replies: 2
 |
•
•
Join Date: Feb 2007
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Timer in xls? 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
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
•
•
Join Date: Feb 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
Thanks,
-m
•
•
Join Date: Feb 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
Private Sub Workbook_Open()
Application.Run "'myxlsfile'!MyMacro"
End Sub
Thanks for those who read my original questions.
cheers,
-m
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Linear Mode
Similar Threads
- Visual Basic Timer/Clock/Countdown. (Visual Basic 4 / 5 / 6)
- Timer Question (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: VBA Help
- Next Thread: how can I fix two child windows in a mdi form in vb 4
