View Single Post
  #6   Report Post  
JMMach
 
Posts: n/a
Default Data Validation - ignore blanks

In the reply to groups window, you will notice an icon with a paper clip,
click on it and locate the document to be attached.
If that does not work for you then simply type the details of the Settings
tab.
TTFN
JMMach

"Neville" wrote in message
...
How does one attach a file to a posting?

"JMMach" wrote:

How about attaching Excel file, or if it has sensitive information then
paste the dialog box into Word or WordPad and attach that to the

message.
TTFN
JMMach
"Neville" wrote in message
...
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?