Userform Multi select List box copy to clipboard

[oxicottin]

Hello, I have a listbox named lbxOracleProduct and that's all it does is show two columns of data that is in a cell range on my Sheet1 and nothing more. I have it set to,

1) ListStylePlain
2) frmMultiSelectMulti

so I can shift select what rows I want to copy to clipboard. I found some code but cant get it to work correctly. First, I select a few rows in my listbox then click the copy button and paste it into word and it copy's ONE of my entire columns and not the other one.

How can I get it to copy to clipboard what is highlighted in my listbox?

Please Login or Register  to view this content.

[AlphaFrog]

Change the 1 to a zero in this line.

Please Login or Register  to view this content.

[oxicottin]

Ok that solved my only copying of one column now it copys both columns BUT it still copys all the data in my list box instead of the rows I shift/selected to copy. Any thoughts?

Thanks,

[AlphaFrog]

Ok that solved my only copying of one column now it copys both columns BUT it still copys all the data in my list box instead of the rows I shift/selected to copy. Any thoughts?

Thanks,

Please Login or Register  to view this content.

[oxicottin]

Awsome! That worked perfectly.... Thanks!