thorpyuk
Well-known Member
- Joined
- Mar 14, 2006
- Messages
- 1,453
Hiya,
I have a spreadsheet that looks like this:
I want to bring up a prompt whenever now() is equal to any of the date / time combinations in column L, regardless of where in the spreadsheet I am working. (or even better, regardless of which application I am working in). The spreadsheet will always be open...
I've tried this code in the workbook_SheetSelectionChange module, but it does not work & gives me an error:
Please can anyone help? Thanks
I have a spreadsheet that looks like this:
![pic.jpg](/board/proxy.php?image=http%3A%2F%2Fi71.photobucket.com%2Falbums%2Fi159%2Fthorpyuk%2Fpic.jpg&hash=2ba882573952d8314b229c0be02e290a)
I want to bring up a prompt whenever now() is equal to any of the date / time combinations in column L, regardless of where in the spreadsheet I am working. (or even better, regardless of which application I am working in). The spreadsheet will always be open...
I've tried this code in the workbook_SheetSelectionChange module, but it does not work & gives me an error:
Code:
If Application.OnTime = Sheets("Callback").Range("L25").Value Then
MsgBox "Please contact " & Sheets("Callback").Range("B25").Value
Please can anyone help? Thanks