Show message if specific text in cell & date check are met

[ipbr21054]

Morning.
On my worksheet in column G will be various dates & Text.
In column A will be a date.

The code advice im looking for is as follows.
If text in column G = POSTED & date in column A is 30 days old then show Msgbox
Once im shown the Msgbox i can take it from there so it doesnt have to check for more than 30 days.


Thats it.
Thanks

 

[ipbr21054]

I changed the format back to DATE and now when i select another sheet then back to this sheet the Msgbox doesnt pop up.

 

[NoSparks]

Beats me.
All I know is it's your date entry not the code.

I changed the format back to DATE and now when i select another sheet then back to this sheet the Msgbox doesnt pop up.

You shouldn't need to be dealing with that at all.

Do yourself a favor and format what exists in column A as real dates
and change the code in whatever user form you're using to write those dates
so they aren't being written as text.
Start another thread for this if you need to.

 

[ipbr21054]

New post now started Thanks