Excel Staff Training Package

[Stuart_Mansfield]

I have just started playing around with VB on Excel.

I have a question regarding pop up message boxes:

I am looking to set up a training package for my staff on site. I so far have it set so that as it gets closer to the required dates the cells change colours (orange for due in 30 days and red for due in the next week or passed). However I would like to arrange for a pop up message to appear as well. I have managed to get it to show up on only one cell. How do I get a message to say something like "Training Package is due in 14 days" for a range of cells (i.e. A4-AF10)?

I wouldn't mind an email being sent to my email box if this is possible as well.

I have seen a lot of people saying you can complete these tasks for one cell, but as stated I want this to work over a range of cells.

Or does someone have a staff training package that is all singing all dancing that I can change to suit my needs?

I hopefully have attached a basic idea of what I am looking to do.

Any help would be great.

Thanks