link pop-up message to a cell

[ash369ster]

Hello

Is there a way i can link pop-up message to a cell value.
currently in cell A i have names and in cell H i have expiry date.

I have managed to have the following VBA which pops-up a message when the expiry is in 3-days. but not i would like to get the pop-up to say Send reminder to (the name in column A).


Any and all help is appreciated.

Thanks in advance

here's my current VBA

For Each cell In Range("H1:H22")
If cell.Value = Date + 3 And cell.Value <> "" Then
MsgBox "Send Reminder to "
End If
Next

[Kamboj]

Please Login or Register  to view this content.