Posted to microsoft.public.excel.misc
|
|
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.
|