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:
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