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

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

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