vba combobox worksheet

[neilp]

Hi All

Got a simple userform - 1 combobox and 4 text boxes.

The combobox has a list of all the sheet names. when a button is pressed, I would like the info that is in the 4 text boxes to be transferred to the next available row in the correct worksheet.

is this doable?

thanks

neil

 

[Fluff]

Something like

Private Sub CommandButton1_Click()
   With Sheets(Me.ComboBox1.Value)
      .Range("A" & Rows.Count).End(xlUp).Offset(1).Resize(, 4).Value = _
         Array(Me.TextBox1.Value, Me.TextBox2.Value, Me.TextBox3.Value, Me.TextBox4.Value)
   End With
End Sub

 

[neilp]

That is perfect

Thanks so much

Neil

 

[Fluff]

You're welcome & thanks for the feedback