none
Multi-Selection Drop Down List RRS feed

  • Question

  • Hi All,

    I am looking for some VBA coding to process the following:

    I have one data validation list (as a named range) "Region" which has the following available as selections

    CGM
    HIOW
    HLNY
    Merseyside
    WY
    -

    I then have a second drop down which is dependent on the "Region" drop down. These selections are based on named ranges for each selection of "Region" (i.e. if "WY" is selected, the following appears:

    Bradford
    Calderdale
    Kirklees
    Leeds
    Wakefield

    What I would like, is to have it so, for both lists, you can select numerous selections separated by a comma?

    I am aware that it is possible and I have scoured the forums for a result, however I encounter "Run time error '94'"

    Steve

    Wednesday, September 9, 2015 9:42 AM

Answers

All replies