I have a UserFrom with a ListBox that allows users to custom rearrange the order of items in the list box. I would then like for the items in the ListBox to be dumped into a specified location on a spreadsheet when the user presses a button in the UserForm. The line items in the list box are populated whenever they open it and the number of items in the list box is variable, so the output list size can also vary.
Before:
After:
Ideal Result:
Before:
After:
Ideal Result: