Validation of data in a cell

[Danie]

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

Thanks for your help,
Danielle

 

[JE McGimpsey]

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

 

[Danie]

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

 

[Bob Phillips]

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]

How do you assume a value?

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)

 

[Bob Phillips]

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)