View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Danie Danie is offline
external usenet poster
 
Posts: 20
Default Validation of data in a cell

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.