Transfer Userform Data into Sheet new row every time

[Amature Excel Guru]

Hello Gurus,

I am new to this portal and hoping you to help me in the VBA.

I have created a multilayer user form for my organization. User form contains multiple combo box, textbox, and checkbox. I have assign a macro to submit button at the end so once that is hit, it will automatically capture all the data into the worksheet ("sheet3").

Only issue i am seeing with the code is that every time it goes to first row and overwrites the data instead of going into the next row. The code reads as below:

Not sure what is wrong here

 

[dmt32]

Hi,
welcome to forum

you have your LastRow variable intialized to an unqualified range so unless the worksheet data is being posted to is the activesheet, you will not get desired result

try update to your code below & see if helps

Sub Submit()
    Dim sh      As Worksheet
    Dim LastRow As Long
   
    Set sh = ThisWorkbook.Worksheets("Sheet3")
   
    LastRow = sh.Cells(sh.Rows.Count, "B").End(xlUp).Row + 1
   
    'rest of code
End Sub

also when posting code, use code tags MenuBar > VBA & place code between the tags

Dave

 

[Amature Excel Guru]

Hi,
welcome to forum

you have your LastRow variable intialized to an unqualified range so unless the worksheet data is being posted to is the activesheet, you will not get desired result

try update to your code below & see if helps

Sub Submit()
    Dim sh      As Worksheet
    Dim LastRow As Long
  
    Set sh = ThisWorkbook.Worksheets("Sheet3")
  
    LastRow = sh.Cells(sh.Rows.Count, "B").End(xlUp).Row + 1
  
    'rest of code
End Sub

also when posting code, use code tags MenuBar > VBA & place code between the tags

Dave

It worked perfectly. Thank you so much for the help

 

[dmt32]

It worked perfectly. Thank you so much for the help

welcome glad issue resolved & appreciate feedback

Dave

 

[Amature Excel Guru]

Can someone help me with the code which i can use to save the excel data from one file to another excel file at different location