TIME LINE IN EXCEL

hi,

I am using Excel 2003. I want to create a time line in the header of the Excel spreadsheet where when i click start it should run and display the time and when it crosses 2 mins it should highlight in red colour so that the user can identify that he crossed 2 mins and when i click stop it should display the time consumed.

Can anyone help me with this.

Thanks in Advance.

Sathish

Do you mean a timer (and not a "time line")?

What do you mean when you write "header?"

Hi Jonathan

Actually i am doing a work in Excel which needs monitoring the time consumption. It can be a Timer or a Time LIne . Time limit for the job is 2 mins so if it exceeds 2 mins i want some change in the Timer to indicate the time is crossing the limit.

header means nothing but top of the excel spreadsheet

I guess you want something like this:

Option Explicit
Dim stopped As Boolean

Sub TimerStop()
  stopped = True
End Sub

Use TimerStart as the macro for your first button, and TimerStop as the macro for the second button.  If you're using OLE button object (rather than form objects), use the code in the CommandButtonX_Click events.

Hi Joathan,

I am getting an error in

start = CInt(Timer)

Hi Satish,

remove the CInt from the code and

declare the "Dim Start as Double"

would solve the problem. Hope tht works.

Regards

Manish