I have a worksheet with a MultiSelect Listbox located in userform. It currently has 10 values that I want linked to a spreadsheet so when they are selected, the column next to it will show as either "True" or "False". In range A1 to A10 in the spreadsheet is the value connected to the listbox and I want the "True" or "False" value to show in range B1 to B10 if the associated value is selected.
Also, the A1 to A10 is dynamic so I want the list box selections to grow as that list grows. I've attached an example.
ListBoxTest.xlsb
Bookmarks