Hi Sandy
if I cancel the data validation error my entry is cleared (that is the
previous entry is restored). But maybe I#m missing something in your
question

Frank

Sandy wrote:
Thanks Frank. That solves part of the problem is there any way to
clear contents when cancel is clicked? Thanks again