copy the value from listbox

[kowol]

I'd like to know how to copy the value using mouse right click from the listbox.
But the listbox data has 6 columns and I want to copy the 1st to 3rd column value so that I can paste the values to clipboard.
In other words, when I click and highlight the low and click the mouse right button then copy the value (2s-123, valve, lot12) to the clipboard.

Thanks

ListBox

column1 column2 coumn3 column4 column5 column6
2s-123 valve lot12 2/1/13 jk order

 

[llkhoutx]

There's DAO code to retrieve any column (hidden or visible) of a selected list row.

Good luck. As a matter of principle, I don't provide code except when I think appropriate.