Need to auto-populate a list.
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
|