| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down lists and forms | Excel Worksheet Functions | |||
| pasting into lists using macros | Excel Discussion (Misc queries) | |||
| Populating Lists in forms | Excel Programming | |||
| Using User forms to enter data into lists | Excel Programming | |||
| Pasting into Filtered Lists (Visible cells only) | Excel Programming | |||
Hybrid Mode
