In summary, I am trying to add new items to a multi-columned listbox on a seperate userform from the one where the user input data is located. I'm in Excel 2010.
The first Userform (addTask) is where a new task can be input. There is a button to upload a subtask which opens a new userform (addSubtoTask) where information about a subtask can be input. There can be multiple subtasks, so I thought a multicolumned listbox (ListTasks) would work to store the different subtasks until the user chooses to add all of the Tasks and Subtasks to the spreadsheet. My code adds the first line to the Listbox but this and almost every other variant rewrites the first line. The one version that let me add multiple rows only worked if I didn't unload the addSubtoTask userform but once i closed it, it would of course start back up rewriting the first row.
Any help would be wonderful.
Thank you
Bookmarks