VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,580 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
Users are working with macros-enables Excel workbook.
Is there an opportunity to generate a VBA message at a specified time?
Example : Excel message pops up at 10pm CET and says "Please stop working and go home".
Thanks
Try executing a code like this:
Application.OnTime "22:00", "MyProcedure"
Also add a module containing this procedure:
Public Sub MyProcedure()
MsgBox "Please stop working and go home"
End Sub
Probably the OnTime function can be called automatically from the Open event of workbook.