Hi!

You can use the data validation feature to add an input
message whenever you select one of the affected cells.

Biff

-----Original Message-----
Could anybody tell me if this is possible?

My example situaton is:
C1:C5 is a list of people's names.

Cells in Column A are Data Validation List based on
=$C$1:$C$5 and drop down choices are made up to A50.

Due to a staff change, text is replaced at C2 with a new
person's name. Now the change reflects in all drop downs
from that point on!

Question:
When I click on any cell less than A51 in Column A that
contains the old C2 name, can an alert message tell me
that this person has left and will not appear in the drop
down current listing?

TIA


.