Hi all,
New to doing Macros, and really not sure where to start, as what I've been trying doesn't seem to work very well.
I have a spreadsheet with a number of review dates, these are in columns K, S, V, X and AA, I am trying to make it so when these are equal to or past todays date, a pop up box appears telling you one is out of date (or multiple if more than one).
In the same spreadsheet, I am trying to get a pop up box to display if the date in column F, is a year old and the data in column G is equal to "specific text"
Both of these are in a worksheet call "Data"
I've managed to get a pop up to work when opening the spreadsheet (just testing/playing), but not on specific formats, any help greatly appreciated.
New to doing Macros, and really not sure where to start, as what I've been trying doesn't seem to work very well.
I have a spreadsheet with a number of review dates, these are in columns K, S, V, X and AA, I am trying to make it so when these are equal to or past todays date, a pop up box appears telling you one is out of date (or multiple if more than one).
In the same spreadsheet, I am trying to get a pop up box to display if the date in column F, is a year old and the data in column G is equal to "specific text"
Both of these are in a worksheet call "Data"
I've managed to get a pop up to work when opening the spreadsheet (just testing/playing), but not on specific formats, any help greatly appreciated.