transfer data form userform to specific sheet

[yoon]

Hye and good morning to all, I have favor to ask which is I need to create userform to insert data about daily report workers. And I need to transfer the data to the specific sheet because I have multiples sheets that relate with specific workers. can yo all help me to build my userform with the coding also as I not have enough knowledge about vba excel

 

[Bosquedeguate]

General code to do this in your UserForm (probably a Button_Click event) is:

Worksheets("sheetname string").Range(range address) = TextBox1, ComboBox1, .... (control name that contains your data).

eg

Worksheets("Sheet1").Range("A1") = TextBox1

 

[yoon]

General code to do this in your UserForm (probably a Button_Click event) is:

Worksheets("sheetname string").Range(range address) = TextBox1, ComboBox1, .... (control name that contains your data).

eg

Worksheets("Sheet1").Range("A1") = TextBox1

I did not fully understand. can you put the detail coding for me. I already build my userform and the last combobox is where I put all sheets that I will put the data. So, can you help me to build the specific coding for the combobox that contain all the sheets( just supposedly I have 4 sheets)

 

[Bosquedeguate]

'sample code for Submit Button
Private Sub btnSubmit_Click()
  Dim wks As Worksheet
  
  Set wks = Worksheets(cbxSheets.Text)

  wks.Range("A1") = TextBox1
  wks.Range("B1") = TextBox2
  wks.Range("C1") = TextBox3
  wks.Range("D1") = TextBox4
End Sub


'sample code to initialize ComboBox (named cbxSheets)
Private Sub UserForm_Initialize()
  Dim wks As Worksheet
  
  For Each wks In Worksheets
    cbxSheets.AddItem wks.Name
  Next
  cbxSheets = "Sheet1"
End Sub

 

[yoon]

okay thank you. But I want to ask can you help me if I want to add another column which is the value of A11/A11/60*A11 and it automatic will count in the sheet without I put the formula in the column?

 

[yoon]

okay thank you. But I want to ask can you help me if I want to add another column which is the value of A11/A11/60*A11 and it automatic will count in the sheet without I put the formula in the column?

I'm sorry wrong formula. The formula is =E/G/60*H

 

[Bosquedeguate]

Yes. Any new sheets that you add will be included in the ComboBox when the form loads.

You might have to move the code to the form Activate Sub