Event Procedure if Date is within timeframe

Hello, I have a tab that I use to record when employees are to be paid vacations. It is called Future Paid Vacations. It is one of many tabs in the workbook, but it is the only one we are really concerned with for this. I have a date listed starting in E3 and so on(The number of rows of data can change) and this date is when employees are to be paid for their vacations. What I am looking for is every time the workbook is opened for a MsgBox to appear if the week that the date listed in column E happens to fall within current week that basically reminds me to check the Future Paid Vacations tab for a Vacation payment. I've been learning VBA thru a course I am currently taking, and know a tiny bit about Event Procedures, but I've not really dealt with codes yet regarding dates, so I am not sure how the wording would go for if the date is within current week. Any help will be appreciated.

Is this what you mean?

Please Login or Register  to view this content.

HI ByteMarks thanks for the response. I did change the name Sheet1 in the code to the appropriate tab "Future Paid Vacations" and I entered today's date in cell E4 to test(There's already an entry for someone in E3 but it's a date outside of this week.) I saved it and it works but it only seems to work if the future paid vacations tab was the last tab the file was saved to and closed and then when the workbook opens up to that tab. Like I mentioned before, I use many other tabs in the workbook and wouldn't always be saving on that tab and closing. When I saved it on a different tab, closed the workbook and then opened it, I wasn't getting any pop-up. The solution is close, it's just that little bit I'm wondering if it can be fixed.

Sorry, try it like this.

Please Login or Register  to view this content.

Perfect! It is displaying the pop-up now no matter what tab I leave off with. I tweaked the code slightly as needed for how I wanted the text to read in the pop-up with date formatting and such. I liked what you did with adding the current week date range to the title of the message box. Your code gives Monday thru Sunday date range but I changed that 2 at the top of the code to 1 and that gave me a Sunday thru Saturday range for that. Got it perfect to how I need it and this will be a big help, so thank you very much for your help!

That's great. You're welcome.