Show cell value in a Msgbox based on IF statement on another column - Excel VBA

[AAS44]

I want to create a Msgbox alert to tell me when employees' contract are coming to an end.

Those contract which are between 4 - 1 month(s) of expiry will have their cells filled in Red:

trigger alert.png

This is my code thus far:

Please Login or Register  to view this content.

However, how do I include a line of code to tell me the EE No. of the employees whose contract are expiring, to be shown in the Msgbox as well?

[Arkadi]

One option:

Please Login or Register  to view this content.