ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Afternoon.
Please could you advise a basic could to transfer values from userform to worksheet.
Some infor for you.
Worksheet called HONDA SHEET
ComboBox1.Value to Cell B21
TextBox1.Value to Cell C21
TextBox2.Value to Cell D21
ComboBox2.Value to Call E21
ComboBox3.value to Cell F21
Here is my attempt but keep getting different RTErrors
Please could you advise a basic could to transfer values from userform to worksheet.
Some infor for you.
Worksheet called HONDA SHEET
ComboBox1.Value to Cell B21
TextBox1.Value to Cell C21
TextBox2.Value to Cell D21
ComboBox2.Value to Call E21
ComboBox3.value to Cell F21
Here is my attempt but keep getting different RTErrors
Rich (BB code):
Private Sub CommandButton1_Click()
With ThisWorkbook.Worksheets("HONDA SHEET")
.Range("B21") = ComboBoxBox1.Value
.Range("C21") = TextBox1.Value
.Range("D21") = TextBox2.Value
.Range("E21") = ComboBox2.Value
.Range("F21") = ComboBox3.Value
End With
End Sub