i am exploring this http://www.contextures.com/xlForm02.html

would like to improve further on...

I have realised if column A1, B1,C1 has been entered,
The forumula will auto got to D2,E2,F2.
Therefore, i would like to ask how do i prevent the new data goes to D2,D3,D4.
By right, it should go to D1,E1,F1.

With historyWks
With .Cells(nextRow, "AM")
.Value = Now
.NumberFormat = "mm/dd/yyyy hh:mm:ss"
End With
.Cells(nextRow, "AN").Value = Application.UserName
oCol = 4
For Each myCell In myRng.Cells
historyWks.Cells(nextRow, oCol).Value = myCell.Value
oCol = oCol + 1
Next myCell
End With

Thanks!