Copy Multicolumn ListBox to Clipboard while keeping column formatting

[dosydos]

Does anyone know how to copy a multicolumn ListBox to the clipboard so that when i paste, it will be in separate columns vs all data in one column?
ex:

Please Login or Register  to view this content.

When I copy to the clipboard right now and then paste the above data concatenates into 1 cell as shown below.

Please Login or Register  to view this content.

I would want the vba to copy to the clipboard so that it will paste into the 4 separate columns as shown below:

Please Login or Register  to view this content.

Below is the current code i have found that is copying from my Listbox on a Userform to the clipboard:
The name of my Multicolumn ListBox is ResultLB

Please Login or Register  to view this content.

[Leith Ross]

Hello Dosydos,

The DataObject only copies text to the clipboard, no formatting is included. You can easily transfer the data from the ListBox to a worksheet without using the clipboard. In your macro, you can then add in any formatting you like.

[dosydos]

unfortunately the data will be pasted to a separate workbook where the location is always changing and completely random, so there is no way to know where to map the location too. This is why i need the data to stay in columns when sent to the clipboard so that i can manually paste where necessary. I have a feeling that there isn't going to be a solution for this project while continuing to use userform Listboxes.

[dosydos]

Update:
I just figured out how to do this correctly.
I need to add a "Tab" to my listbox while sending it to the clipboard. This way when i pasted the information it correctly understood where the columns were. Before i was stupidly using "SPACE". Correct code is below

Please Login or Register  to view this content.