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

  • Thread starter Thread starter ankur
  • Start date Start date
A

ankur

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation based on Cell Value 4
Locking and Unlocking Cells via VBA 3
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Conditional Validation In Excel 1
make use of cell defined data validation in vba 1
Track Changes History sheet (Who changed the last cell) 1
Data Validation List (conditional) 2
Data Validation - Dependent List 3

Back
Top