did 2007 excel address some of the validation requirement as below
1) Apart from validating list of the values, can it throw different
pre-defined messages for defined input values and different error alerts for
different type of invalid inputs

I don't have 2007, so don't know if it has this feature. One method would
be to use Worksheet_Selection and Worksheet_Change events. What exactly did
you want to do?

"Karuna" wrote:

did 2007 excel address some of the validation requirement as below
1) Apart from validating list of the values, can it throw different
pre-defined messages for defined input values and different error alerts for
different type of invalid inputs

I am having a validation in Cell (Job1,Job2,Job3)
i am able to put the above validation
if the data entered is other than job1 i need a message or else i don't want
a message

note: I want to do this with Normal excel not through macros or VBA


"Barb Reinhardt" wrote:

I don't have 2007, so don't know if it has this feature. One method would
be to use Worksheet_Selection and Worksheet_Change events. What exactly did
you want to do?

"Karuna" wrote:

did 2007 excel address some of the validation requirement as below
1) Apart from validating list of the values, can it throw different
pre-defined messages for defined input values and different error alerts for
different type of invalid inputs