I am looking for a way have a user paste (from excel) a list of values
into a form object, say a textbox, and then extract the data from that
textbox as a list. When I paste a list of values into a textbox
manually it leaves it all on one line and seperates the values with a
paragraph symbol and no spaces.

In short I would like to give the user the option to paste or manually
type a list which I can then modify and use to query a database. Also,
I would like it displayed as a list, and not a continuous illegible
string.

I have a feeling I have hit a limit of vba but I'm hoping you guys can
conjure something. Thanks as always.