Need help inserting data into certain worksheet from UserForm

[curtryan45]

I currently have a userform with controls that has a submit button. It submits fine but it always goes into the active sheet (my starting sheet). I need it to go into a worksheet (ChangeData) in the same workbook. Here is the code I currently use

Private Sub btnSubmit_Click()
Worksheets("ChangeData").Range("B2").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = cboPhase.Value
ActiveCell.Offset(0, 1) = cboStep.Value
ActiveCell.Offset(0, 2) = txtTool.Value
ActiveCell.Offset(0, 3) = txtDesc.Value
ActiveCell.Offset(0, 4) = txtName.Value
End Sub

Find the next available row is already taken care of. Thanks

 

[iggydarsa]

it looks like it should work but maybe try replacing ActiveCell with Selection

 

[curtryan45]

I figured it out, for some reason it worked when I changed Worksheets to Sheets separated Sheets.Select and Range.Select