Hi
sort of novice to harder parts of VBA with excel this to me is advanced but to the more experienced may not be.
I have a data entry form where users select data from rowsource data only when a combo box is selected to add what shift Day or Night when Night is selected a second userform appears. This form requires times that certain checks were completed what I would like is for these times to be passed back to the same row in the data sheet that userform 1 does when command button of saved has been selected at the end of the population of all the combo boxes ??
this is the normal code I use when saving data back to a worksheet this works but it puts in on a line above the userform 1 data
Private Sub cmdSavetime_Click()
Dim lastrow As Long
With Worksheets("tbl_data")
lastrow = .Range("A" & Rows.Count).End(xlUp).Row
.Cells(lastrow + 1, "L").Value = cbT2.Value
.Cells(lastrow + 1, "M").Value = cbT3.Value
.Cells(lastrow + 1, "N").Value = cbT4.Value
.Cells(lastrow + 1, "O").Value = cbT5.Value
.Cells(lastrow + 1, "P").Value = cbT6.Value
End With
End Sub
thanks in advance