Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have searched the message boards for advice on creating a pop up message
box, but unfortunately I have found the advice on the use of OnTime confusing. For example, advice is not explicit on where to put various code in the spreadsheet (e.g., module / This Workbook etc) What I would like is to have a message box pop up every 15 mins from a date/time that is stored somewhere in my spreadsheet or more preferably within the code itself. From that date/time i would like the message to then pop up every 2 minutes when the spreadsheet is used. people quote from the page http://www.cpearson.com/excel/OnTime.aspx, however i find this site unhelpful on this matter as it assumes expertize on where to place code. Can anyone provide specific code together with instructions for where to place the code such that the code works when the sheet is opened? Thanks, Roger |