Thanks very much for all your help Sheeloo. Your solution resolved my issues.

"Sheeloo" wrote:

Pl. send me a mail to me (add hotmail.com to to_sheeloo to get my id) so that
I can send a working copy of the sample code..

Did you add the following to the IF loop
If lReply = vbNo Then
Target.Value = ""
Target.Select
End If

I missed Target.Select but it was there in the tested code...
"Labkhand" wrote:

I am not sure how it is working for you since it is not for me. After going
back to a cell following responding NO to the add to list prompt, when i
enter the new date, it doesn't re-display the ADD TO LIST prompt...cursor
just moves to the cell below the activecell!!!!

Can you please retest your code?

Thanks