I am creating a form that will be used to input data, in that form there are 6 regular text boxes and two multiple selection listboxes that i have already created and work perfectly except that only one selection shows up on the worksheet. I want the output to be comma delimited in the cell. Also I want the named ranges that are supplying my listboxes to be dynamic and update when new values are entered in my LookupLists Sheet.
The two listboxes are named: listCarlisle and listAction
Any help would be awesome, Thank you in advance!
Code:
Bookmarks