Pasting lists into Forms

  • Thread starter Thread starter Kigol
  • Start date Start date
K

Kigol

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.
 
Hi,
What is the setting of the Multiline property of the Texbox? Try setting it
to True.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with UserName 5
loop to copy paste 3
copy text from textbox to another application 3
VBA: How can I use a string variable as autofilter criteria? 4
Userform textbox string to header causes unwanted double spacing 4
Trying to make a form for SEO. 1
Data Validation - Do not want to allow pasting into the cell 3
Copy range based on input 1

Back
Top