Linking multi-select ListBox to Cells Value

Hello,

I have a multi-select Listbox1 with 4 valuees:
Monday
Tuesday
Wednesday
Thursday

I want to link it to a cell such that depending on the selections a column of YES or NO values is produced.
For example, if user selects only Monday and Wednesday then the following is produced in a different worksheet
YES
NO
YES
NO


Can anyone help with Macro?\

Thank you!

Welcome to the forum!

Please Login or Register  to view this content.