Forum Discussion

Missile64's avatar
Missile64
Copper Contributor
Mar 22, 2024
Solved

Multi Select & Dependent Drop Downs

I have been trying to create a number of multi select drop downs and a dependent drop down (which is sourced from one of the multi select drop downs). The attached example I have Column 1 & 2 as mult...
excel
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Mar 24, 2024

    Missile64 

    See the attached version.

    UpdateValidation now lets you specify an arbitrary number of other columns to be affected, by specifying their offsets.

    In the Worksheet_Change event procedure,when column A is modified, the line

     

    Call UpdateValidation(Target, 1, 5)

     

    updates the data validation source for the columns 1 and 5 to the right of column A, i.e. columns B and F.

    If you wanted to add column H (7 to the right of column A), you'd use

     

    Call UpdateValidation(Target, 1, 5, 7)

Missile64's avatar
Missile64
Copper Contributor
Mar 24, 2024
The same as column 2 would be good thanks.
Marking my reply was in error, wanted to mark your first response.
HansVogelaar's avatar
HansVogelaar
MVP
Mar 24, 2024

Missile64 

See the attached version.

UpdateValidation now lets you specify an arbitrary number of other columns to be affected, by specifying their offsets.

In the Worksheet_Change event procedure,when column A is modified, the line

 

Call UpdateValidation(Target, 1, 5)

 

updates the data validation source for the columns 1 and 5 to the right of column A, i.e. columns B and F.

If you wanted to add column H (7 to the right of column A), you'd use

 

Call UpdateValidation(Target, 1, 5, 7)