Hello,
I am attempting to use a list box with the multiselect items in a Userform and I am trying to find a way to have the form show the information in a separate table under the proper heading as separate line items.
So far I have been able to get the form to put the items in the correct place in my table, but I cannot get them to list on new lines. Using the comma separation just looks messy too for my list items. The ultimate goal would be to be able to filter the table by each item, but I don't think that's possible at all without having them in new rows...
Any suggestions?? I think needs to be adjusted below is: If .Selected(i) = True Then s = s & .List(i) & vbNewLine
HTML Code:
Bookmarks