Pasting lists into Forms
 

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.

Pasting lists into Forms
 

Hi,
What is the setting of the Multiline property of the Texbox? Try setting it
to True.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Kigol" wrote:

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.

Pasting lists into Forms
 

On Nov 28, 3:26 pm, sebastienm
wrote:
Hi,
What is the setting of the Multiline property of the Texbox? Try setting it
to True.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com



"Kigol" wrote:
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.- Hide quoted text -

- Show quoted text -

Ha, well imagine that. Thanks.