How do I validiate the data entered in a cell just after the user has entered
it.

Thanks for your help,
Danielle

First, take a look at the "Prevent entry of invalid data in a cell"
topic in XL Help.

For more, see

http://www.contextures.com/xlDataVal01.html




In article ,
Danie wrote:

How do I validiate the data entered in a cell just after the user has entered
it.

Thanks for your help. What I am trying to do is when a user filters his name
from a list it must be equal to his user Name in Tools, Options. If he chose
the wrong name I must display an error message.

Can you help me.
Thanks,
Danielle

"JE McGimpsey" wrote:

First, take a look at the "Prevent entry of invalid data in a cell"
topic in XL Help.

For more, see

http://www.contextures.com/xlDataVal01.html




In article ,
Danie wrote:

How do I validiate the data entered in a cell just after the user has entered
it.

Why do the filter, why not just assume that value?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danie" wrote in message
...
Thanks for your help. What I am trying to do is when a user filters his
name
from a list it must be equal to his user Name in Tools, Options. If he
chose
the wrong name I must display an error message.

Can you help me.
Thanks,
Danielle

"JE McGimpsey" wrote:

First, take a look at the "Prevent entry of invalid data in a cell"
topic in XL Help.

For more, see

http://www.contextures.com/xlDataVal01.html




In article ,
Danie wrote:

How do I validiate the data entered in a cell just after the user has
entered
it.

How do you assume a value?

"Bob Phillips" wrote:

Why do the filter, why not just assume that value?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danie" wrote in message
...
Thanks for your help. What I am trying to do is when a user filters his
name
from a list it must be equal to his user Name in Tools, Options. If he
chose
the wrong name I must display an error message.

Can you help me.
Thanks,
Danielle

"JE McGimpsey" wrote:

First, take a look at the "Prevent entry of invalid data in a cell"
topic in XL Help.

For more, see

http://www.contextures.com/xlDataVal01.html




In article ,
Danie wrote:

How do I validiate the data entered in a cell just after the user has
entered
it.

I mean if you want them to filter to a particular value, just use that value
in the first place, bypass the filter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Danie" wrote in message
...
How do you assume a value?

"Bob Phillips" wrote:

Why do the filter, why not just assume that value?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Danie" wrote in message
...
Thanks for your help. What I am trying to do is when a user filters
his
name
from a list it must be equal to his user Name in Tools, Options. If he
chose
the wrong name I must display an error message.

Can you help me.
Thanks,
Danielle

"JE McGimpsey" wrote:

First, take a look at the "Prevent entry of invalid data in a cell"
topic in XL Help.

For more, see

http://www.contextures.com/xlDataVal01.html




In article ,
Danie wrote:

How do I validiate the data entered in a cell just after the user
has
entered
it.