Change Validation list in the adjecent cell on the Basis of Value in the Current Cell
 

Hi All,

Help Required. I wish to Change Validation list in the adjecent cell on
the Basis of Value in the Active Cell. I understand that I can achieve
this using a cell activate event and then putting a code to delete and
add a validation in the adjacent cell.

However, It would be great if there is any other good way of achieveing
this.


Regards
Ankur

Change Validation list in the adjecent cell on the Basis of Valuein the Current Cell
 

Without programming, you can use a dependent data validation list, as
described he

http://www.contextures.com/xlDataVal02.html

ankur wrote:
Help Required. I wish to Change Validation list in the adjecent cell on
the Basis of Value in the Active Cell. I understand that I can achieve
this using a cell activate event and then putting a code to delete and
add a validation in the adjacent cell.

However, It would be great if there is any other good way of achieveing
this.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html