In the thread: http://www.mrexcel.com/forum/showthread.php?p=1923351#post1923351 Norie wrote:
James
This happens to be exactly what I am trying to create right down to the add/delete/alter buttons at the moment! I've tried searching for a clue on how to add multiple lines of text that I create from a TextBox one at a time to a listbox, but haven't had any luck. I also don't know where to start with altering/adding or removing the text once it is in the ListBox, and in indeed how to then copy each line to a column in the workbook. So everything really! Any help would be much appreciatedOriginally Posted by Norie
Have you considered using a listbox?
Perhaps in combination with a combobox, textbox and command button.
User select makes selection from combobox,textbox etc hit's the command
button (or presses Enter if it's Default property is set to Yes), data added to listbox, other controls cleared...
Then once the user is done they can review what they've chosen in the listbox and with another command button commit it to a worksheet(s).
This could be further enhanced by adding other controls to add/delete/alter etc
If you post back with more specific details and some sample data/results I'm sure we will be able to give more specific help.
James