So I need a way for excel to pop up reminders for things that are due.
For example. 3 collums name, date one, date 2.
If date 2 is not filled in 21 days after date one. It should pop up with please fill in date 2.
This is for use to remind about vaccinations
theres about 20 pages so cant all be checked every day manually
Something like:
This will obviously only check 1 row, I'm unsure about the structure of your worksheets without a template so I cannot help any more than that until you upload an anonymous template.
Please Login or Register to view this content.
I think BeforeClose event will best suit this scenario.
Assuming Col. A is Name, B is Date1 and C is Date2, then
Place the following code on ThisWorkbook Module.....
So once user tries to close the workbook, the code will highlight the col. C if it is not filled as per the criteria and workbook won't be closed unless user fill all the dates in col. 2 in the highlighted cells.Please Login or Register to view this content.
You may use the following code for Worksheet_Change even to make sure that user only inputs the valid dates in col. C.
Right click on the Sheet Tab --> View Code --> and place the below code on the opened code window.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks