Checking if my clock in my spreadsheet is working using VBA

[Roadhouse]

Hi I havea 24hr clock in cell C2 sheet 1 in my excel workbook 13:10:10 this how it looks hrs/mins/secs I want to use VBA to check if this clock stops for more then 300 seconds if it does show a mesage box with "spreadsheet not updating". Is it possible to put in a module? can any one help?

[Leith Ross]

Hello Roadhouse,

To provide you with a solution, you need to provide more details.

What is the code behind your clock?
Is this sheet being updated by an Query?
Are you timing the user's activity?
Does this apply only worksheet?
What triggers the clock - keyboard or mouse movement?

You could answers these questions individually or save time and post your workbook. Having the workbook will allow solutions to be tested before being posted back.

[Roadhouse]

Hi
What is the code behind your clock?
I attach my excel workbook to software which inputs a clock into C2 and updates the clock

Is this sheet being updated by an Query?
No

Are you timing the user's activity?
No

Does this apply only worksheet?
It only applies to worksheet 1

What triggers the clock - keyboard or mouse movement?
Nothing truggers the clock it automatically updates

[Leith Ross]

Hello roadhouse,

This is not making sense.
Okay, you said...

I want to use VBA to check if this clock stops for more then 300 seconds

'

How can the clock stop if it is controlled by another program?

I attach my excel workbook to software which inputs a clock into C2 and updates the clock

[Roadhouse]

hi sometime the spreadsheet disconnects from the software without me doing anything so the clock can't update I'm trying to catch this problem when it happens.