Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving timeline
Does anyone know if it is possible to make a timeline in excel, that has a
realtime line in the middle of the sheet and the sheet drifts by using realtime as center (sort of a movement report sheet for following movements where you have 24 hours pr day, and can put in markings for an aircraft (or several) and it drifts by folowing the computer clock?) I am trying to make it to follow aircraft movements (3-10 sectors pr day) which will help me hold track of all movements. Idea is to fill in as we set up flights and show this "moving timeline" on a screen in the office so all can follow all movements and keep track. I know this might seem complicated and if any other program than excel can be easier, please recomend one:-) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving timeline
On Apr 5, 11:16*am, Sjefsfragle
wrote: Does anyone know if it is possible to make a timeline in excel, that has a realtime line in the middle of the sheet and the sheet drifts by using realtime as center (sort of a movement report sheet for following movements where you have 24 hours pr day, and can put in markings for an aircraft (or several) and it drifts by folowing the computer clock?) I am trying to make it to follow aircraft movements (3-10 sectors pr day) which will help me hold track of all movements. Idea is to fill in as we set up flights and show this "moving timeline" on a screen in the office so all can follow all movements and keep track. I know this might seem complicated and if any other program than excel can be easier, please recomend one:-) Hi, Not sure if this is exactly what you are after, but here goes: Public RunWhen As Double Public Const cRunIntervalSeconds = 2 ' two seconds Public Const cRunWhat = "The_Sub" ' name of procedure to run Sub StartTimer() RunWhen = Now() + TimeSerial(0, 0, cRunIntervalSeconds) Application.OnTime EarliestTime:=RunWhen, Procedu=cRunWhat, Schedule:=True End Sub Sub LoopTimer() RunWhen = RunWhen + TimeSerial(0, 0, cRunIntervalSeconds) Application.OnTime EarliestTime:=RunWhen, Procedu=cRunWhat, Schedule:=True End Sub Sub The_Sub() With Range("C9:L11") .Columns(1).Offset(0, .Columns.Count) = .Columns(1).Value .Value = .Offset(0, 1).Value End With LoopTimer End Sub Stick some data in range C9:L11 and then run the 'StartTimer' macro. This will give a demonstration of the technique at least. If it is what you want, then just change the range to scroll and the interval and there you go. Unfortunately I can't take credit from this, it is a modification of code from he http://www.cpearson.com/excel/OnTime.aspx This site will also give you tips on how to stop the timer as well, which is something I didn't include. Cheers, Ivan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
best timeline | Charts and Charting in Excel | |||
Timeline Chart? | Excel Discussion (Misc queries) | |||
timeline | Charts and Charting in Excel | |||
How do I put a timeline into a calendar? | Excel Discussion (Misc queries) | |||
Timeline Chart? | Charts and Charting in Excel |