| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set cell value if adjecent cell value is greater than 0 | Excel Worksheet Functions | |||
| change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
| Change/cycle cell entry to next option from validation list (macro | Excel Programming | |||
| monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
| Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? | Excel Programming | |||
Linear Mode
