Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set an alarm to work on excel
i have delivery/collection spreadsheet and i'm trying to set some sort of
worning to tell me that a collection is over 30mins late any tips |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set an alarm to work on excel
It'll take VBA code to do this type of processing. See:
http://www.ozgrid.com/Excel/run-macro-on-time.htm http://www.cpearson.com/excel/OnTime.aspx and http://msdn.microsoft.com/en-us/library/bb223501.aspx It will take more information than you've provided here to come up with a complete solution, so you need to tell what sheets are involved and what column or columns on the sheet are involved and how they are involved (which has the time of collection in it, do you want to put value into another column on same row?) that kind of thing. P.S. Remind me not to borrow from you -- I've got enough troubles with those who don't worry until the payment is 30 DAYS late, not sure how I would deal with only 30 minutes! <grin "sd5665" wrote: i have delivery/collection spreadsheet and i'm trying to set some sort of worning to tell me that a collection is over 30mins late any tips |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I set an alarm Excel? | Excel Discussion (Misc queries) | |||
How to set an alarm in excel... | Excel Discussion (Misc queries) | |||
How can I set an alarm in Microsoft Excel | Excel Discussion (Misc queries) | |||
can I set a date alarm in Excel | Excel Discussion (Misc queries) | |||
How can a set an alarm in Excel? | Excel Discussion (Misc queries) |