Validation: - different messages for defined input values

  • Thread starter Thread starter Karuna
  • Start date Start date
K

Karuna

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?
 
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
 
Back
Top