VBA Data Validation - Multiple selections, each column has its own validation list

Hi all,

I wanted to set up a VBA to set data validation for my daily work. But I'm too new to VBA so I couldn't write a more complicated one to meet my rather complicated need. I could manage to create multiple choice validation VBA but couldn't fulfill other requirements. Could you kindly help?

My issue:
- A workbook containing 02 sheets. "Sheet 1" is in fixed format with 6 columns. Columns B, D, F require to apply data validation. All columns require multiple selections and each selection is separated by a ";". Each column has its own corresponding validation list listed in 2nd Sheet - "Validation Lists". Data in Validation Lists columns is not fixed, additional criteria may be added later.

- Column C will be auto-populated based on what is selected in column B; Column E is based on column D. Values for Column C and E are also listed in Validation Lists.

- And I would like to enable this VBA for similar workbooks with the same template format in the future.

Please find the sample template in attachment.

Thank you very much for any help or advice

In sheet1 just select 1 cell in Column B, @ the row you want to insert choosen criteria

userform appears, here you choose the items from 3 listboxes and ending with button insert


Kind regards
Leo

@ LeoTaxi: Wow, your version is truly amazing. So advanced and creative!

I would like to ask for a small favor if you could make the corresponding data after selecting the items in Category and Condition column non-duplicated? For example, in column B, if Living Room and Bedroom ( which both belong to Category A), Category A will only appear once instead of twice?

Thank you so much!

No duplicates in this

Cheers
Leo

Thank you so much! The code works perfectly!

Best Regards,