|
-
Nov 19th, 2005, 07:05 PM
#1
Thread Starter
Junior Member
Need Help With Using/(finding) Timer in Excel !
okay here's the plan:
I need to write a macro for excel that will display a number ("B") real-time alongside a movie (it would be preferable for the movie to also play on the form using shockwave or something could someone please instruct me as to how to do that?) Here's a hypothetical first few lines of the data in Excel (A is the time, and B is the number that needs to be displayed):
VB Code:
A B
1 12.00.01 55
2 12.05.01 58
3 12.07.02 46
4 12.09.05 23
5 12.11.04 67
... (and so on for about umm several thousand lines)
What I need to do is use the timer to display the value of "B", after the correct interval of time. For example, the first value ("B1") appears immediatley, and then five seconds later I need for the value of "B2" to be displayed.
The interval between new numbers needs to be something like this (where x equals the row because I'm using a loop):
Right now (having never written a macro/program in VBA before) I am having trouble finding the "timer" control. There are hundreds of "Additional Controls" and I don't want to sort through them. I really have no idea what I am doing with VBA so thanks for the help in advance. Keep in mind that I have only taken Programming 1 last year, I am 15, and my VB skills are so incredibly limited, so if possible, please explain everything fully and don't assume that I know anything
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|