VBA Userform Add Button will not move
I am working on a UserForm with excel VBA. As a newbie to this, I am trying to get my “add” button to do the following actions: 1) put the user provided information from the text and comboboxes in sepecific columns and cells, 2) clear all of the text and comboboxes, and 3) grab text from three other columns (B,C,and D or 2, 3, 4) in the next row and populate the textboxes in my UserForm. I need help with this. Here is the situation. I am providing the numbers because some think of the numbers more so than column lettering. The Userform information should be deposited on E2 or 2,5 through L2 or 2,12 presently my code does not do this. Then, clear everything out. Next, the text in row 3 columns B, C, or D should go into textbox1, textbox2, and textbox3. This process needs to occur until there isn’t anymore valid text in B, C, or D. My code is putting the entered information in the last row, and then clearing the form, and it is NOT populating the form with the next row of information as I described above. I have worked on this for 3 days, and I am completely confused. Here is my code: