ashish1974
New Member
I have multiple drop-down columns which are dependent on each other. This i have implemented using offset function under data validation. Its drawback is say that once user enters value in col 1, gets appropriate options in col 2 and selects a valid value in col 2. But then user goes back to Col 1 and changes value. Now the value in col 2 is invalid but excel does not automatically gives any error message. It can be checked by user by Circle Invalid Data in Data Validation.
i wish to automate this using Worksheets(1).CircleInvalid VBA code. But this CircleInvalid function seems to not work with dynamic drop down validations. It would work with static list but not with dynamic drop down validations built using offset function. Same problem with Cell.Validation.Value.
Is there a way around? Pls help.
i wish to automate this using Worksheets(1).CircleInvalid VBA code. But this CircleInvalid function seems to not work with dynamic drop down validations. It would work with static list but not with dynamic drop down validations built using offset function. Same problem with Cell.Validation.Value.
Is there a way around? Pls help.
