VBA- Multiple selection dependent list

[OK21294]

Hello,

I am creating a data base in which I need to control the entries for two separate categories. e.g. Regions and counties.

I have a column for Regions and a column for counties.

My end goal is to have a Userform or list for Regions which pops up and lists all the regions in the UK, and for the user to be able to select multiple regions. After the Regions have been chosen, I would like the user to be able to select multiple counties based on whatever region/s have been chosen.

For example, if the user was to choose South East and Greater London, all the counties/boroughs in the South East and London Boroughs would be shown in the drop down list for Counties.

So far I have got the Userform to select the Regions but have am struggling to do the rest- any help or suggestions would be very much appreciated!

Thanks

 

[OK21294]

Hello,

I've got the Userform set up however I need the content from Listbox1 to go to the active cell and then the content from listbox2 to go to the column next to it.

How would I do this?

Thanks for you help

 

[Fluff]

You have already asked that question here https://www.mrexcel.com/forum/excel-questions/1065555-vba-userform-help-post5117270.html#post5117270

Please do not post the same question multiple times.