How do I paste some lines of text into a multicolumn listbox on a
userform? The text will be pasted to the clipboard from. typically, a
text editor. It would be a variable number of lines of text, say 20+.
Then on clicking or tabbing to the listbox to give it the focus I want
to Ctrl-v to paste the text into column 2.

In addition to pastng the text the listbox event would add a line
number in column 1. So if the text on the clipboard was:
Tom
Dick
Harry
This would appear in the listbox as:
1 Tom
2 Dick
3 Harry

I can't even work out which event to use to do the paste.

Grateful for any code segments or pointers.

....then once it's in the listbox the user can drag and drop from the
listbox to a textbox on the same form but we'll leave this for later.
Thanks