Hey all, I'm a novice to vb coding (and I have never done vba coding before), but I'm trying to develop something to help me time things out on an excel sheet. Here is a link to the excel sheet I have developed so far.
https://docs.google.com/leaf?id=0B_...NzBiNi00OTk4LTg4YjYtZDRmYzIyNTY0OWFk&hl=en_US
It is called a rundown, and it is basically a list of events that occur in a TV program such as a news show or talk show.
I have included comments in some of the cells to explain their purpose. All columns with a yellow header should remain user editable.
Basically, I'm trying to do 2 things:
1) Upon clicking a start button, the green cell needs to count up, and stop when clicking a stop button.
As this runs, hopefully the RED and BLUE cells, and ORANGE and purple columns update accordingly.
2) Replace the orange and purple columns with a single column that counts down to end, and reports back if heavy... the purpose: add a third button that advances down the rundown, that way when moving into the next element, we can see how light or heavy on time we are with the previous element, so we can add or subtract that same amount of time from future rundown elements. (It's quite hard for hosts/talent to remain on time all the time through a show.)
Does anyone have an idea how to accomplish the first thing at least? I know in VB6 how to create the timer, but there is no timer object in VBA.
Much appreciated,
Ed M.
ehmtwo@gmail.com
https://docs.google.com/leaf?id=0B_...NzBiNi00OTk4LTg4YjYtZDRmYzIyNTY0OWFk&hl=en_US
It is called a rundown, and it is basically a list of events that occur in a TV program such as a news show or talk show.
I have included comments in some of the cells to explain their purpose. All columns with a yellow header should remain user editable.
Basically, I'm trying to do 2 things:
1) Upon clicking a start button, the green cell needs to count up, and stop when clicking a stop button.
As this runs, hopefully the RED and BLUE cells, and ORANGE and purple columns update accordingly.
2) Replace the orange and purple columns with a single column that counts down to end, and reports back if heavy... the purpose: add a third button that advances down the rundown, that way when moving into the next element, we can see how light or heavy on time we are with the previous element, so we can add or subtract that same amount of time from future rundown elements. (It's quite hard for hosts/talent to remain on time all the time through a show.)
Does anyone have an idea how to accomplish the first thing at least? I know in VB6 how to create the timer, but there is no timer object in VBA.
Much appreciated,
Ed M.
ehmtwo@gmail.com
Last edited:
