Hi JMMach,

I have tried to paste the screenshot, but the Paste option is greyed out
when I try to paste it here.

"JMMach" wrote:

Provide information, or better yet, a screen capture of the Data Validation
dialog box with the Setting tab selected (User ALT+PrintScreen to copy the
image to the Windows Clipboard, then paste into your post reply and indicate
what range was selected when you defined the Data Validation..
I need to see how you defined the settings then I might be able to tell you
where you are missing the boat.
TTFN
JMMach, MOUS Master

"Neville" wrote in message
...
I have set up a data form and have data validation rules on the various
input
cells. I see that there is an option called "Ignore blanks" in the data
validation settings, which is supposed to restrict someone from entering
past
an input cell without entering valid data, if the "Ignore blanks" box is
unchecked. I have tried to do this, but it does not seem to work. Please
could someone tell me what I am doing wrong?