View Full Version : Solved: TIMER SCALE IN EXCEL

01-26-2010, 06:18 AM

I am doing a work in Excel which needs time monitoring. The time limit for a job is 2 mins. I need a timer scale in the Excel so that when i am doing my work i can monitor. If the time exceeds 2 mins i need a change in color in the Scale so that the user will be aware that the time is exceeded.

Thanks in advance

01-27-2010, 01:04 PM
There are two in the KB:

A Countdown Timer (http://www.vbaexpress.com/kb/getarticle.php?kb_id=478)
Lock Excel if No Activity Then Log-off if Wrong PIN Entered (http://www.vbaexpress.com/kb/getarticle.php?kb_id=516)

If you wanna search the KB use:
Search Knowledge base (http://www.vbaexpress.com/kb/getarticle.php?kb_id=818)
A very handy reference by mdmackillop.

01-27-2010, 01:16 PM
add in (xla file) and comment

01-28-2010, 05:38 AM
Re the KB Search, for some reason Table numbers have changed. Correct this section of the code to get the data.

With objWeb
.WebSelectionType = xlSpecifiedTables
.WebTables = "15" ' Identify your HTML Table here
.Refresh BackgroundQuery:=False
.SaveData = True
End With