Select sheet name from userform combobox and add data in the selected sheet

[KingGoku]

Hi there,

I am trying to use excel userform combobox to select sheet name and want to add data in selected sheet from userform. would like help with code. thank you

 

[DanteAmor]

Hola @KingGoku, welcome to MrExcel board.

Here a simple example

Private Sub CommandButton1_Click()
  Sheets(ComboBox1.Value).Range("A5").Value = TextBox1.Value
End Sub