Hi all,
I'm having an issue with this one.
I have uploaded an example workbook.
I need a code which fires some other codewhenever a range of cells change which are within 5 days of todays date. Hence, the msgbox would fire if anything in yellow was changed (B16:D21) and then tomorrow the range would be slightly different (B17:D22), etc![]()
MsgBox ("Test")
Todays date will always be in A1.
Bookmarks