Private Sub CommandButton1_Click()
Dim RowCount As Long
Dim benefits, total As Single
If Me.txtName.Value = "" Then
MsgBox "Please enter a name", vbExclamation, "Employee Data"
Me.txtName.SetFocus
End If
'Range("A5") = txtName.Text
If Not IsNumeric(Me.txtSalary.Value) Then
MsgBox "The Amount box must contain a number.", vbExclamation, "Employee Data"
Me.txtSalary.SetFocus
End If
'Range("B5") = txtSalary.Value
benefits = txtSalary.Value * 0.5
'Range("C5") = benefits
total = txtSalary.Value + benefits
'Range("D5") = total
RowCount = Worksheets("Sheet2").Range("A4").CurrentRegion.Rows.Count
With Worksheets("Sheet2").Range("A4")
.Offset(RowCount, 0) = Me.txtName.Value
.Offset(RowCount, 1) = Me.ComboBox1.Value
.Offset(RowCount, 2) = Me.ComboBox1.Column(1) '<<<<<<< this is my soloution
.Offset(RowCount, 3) = Me.txtSalary.Value
.Offset(RowCount, 4) = benefits
.Offset(RowCount, 5) = total
End With
End Sub