Checking if the clock in C2 is updating

[Roadhouse]

Hi is there anyway with VBA to check if the clock in C2 is updating I want to check if it pauses for 300 seconds the tell me with a mesage box. Can anyone help

[Captain Sensible]

What do you mean by pauses? And what are you trying to acheive? Is the program running slow , losing connection etc

I guess your best way is using Application.Ontime so you'd avoid any situations where BA had stopped updating the sheet and therefore any worksheet changes/calcs had stopped. Try messing around with this in a module or call it upon openng the worksheet, basically it'll just call itself and look every 15 seconds to check the value in E2 against the current time. Change that 00:00:15 to whatever you want , I didn't set it to 00:05:00 as it could potentially let thru a 00:09:59 delay

Code: Select all

Sub Check_delay()
If Time() - TimeValue("00:05:00") > Range("E2").Value Then
    MsgBox "Over 300 seconds"
   
   
    End If
     
    Application.OnTime Now + TimeValue("00:00:15"), "Check_delay"
   
End Sub


[Roadhouse]

Hi Captain thanks for the reply I am losing connection for some reason so I hoping I can use some code to check if it has lost connection then I can send an email

[Captain Sensible]

Internet connection or connection to BA, if it's the internet might be best to look at other ways to monitor that as if it goes down not sure how you'd be able to send an email. Is it a VPC or something surely they have their own softwre to monitorup times or you could just ping the IP every so often to check it's up.