Hello.
I have a userform with 2 parts, the 2nd part originally I have 10 text boxes and with a add button, the data with then show on the listbox, code as below
It works perfectly however now I need to add 8 more text boxes.
Listbox Additems only can show max 10 columns.
I try to search online, find something like this, but dont know how to apply in my case.
Especially the "Textbox" & i, since I have more textbox in part 1, seems it can't work.
I need to add new data in the excel sheet through the userform, so cannot use RowSource method.
Can anyone help to modify? Thank you very much.
Bookmarks