I have a userform working as expected; checkboxes filter data on a spreadsheet and when the user is done, the user hits a button and the filtered data lands on a listbox within the form. Problem is the user requirement has changed. Users now need to copy the contents from the listbox; think copy and paste into who knows what. The contents of the listbox will be a simple, single column of text data. A bit of research validates that we cannot copy text from the list box. Please point me in the right direction – what should I be populating the filtered results in? I first thought a text box was appropriate but it seems that text boxes are designed around user input, I tried to copy data from the listbox into a text box, no luck.
Thank you in advance for any direction.
Bookmarks