Hi insomnai,

We can start with the first part, the data entry and go from there.

In the excel vbid go to insert and select "userform"

from the control toolbox click on textbox and add your 4 textboxes to the userform.

Then you will want to add two command buttons. One to add the data to the sheet and one to cancel the whole operation.

Double click on the button you are going to use to add data to the sheet and you will enter the code module for the userform and the insertion point will be in the procedure for the command button.

Add this code which finds the last row and adds your textbox values to that row......

[VBA]Dim LastRow As Object
' Set LastRow = Sheet1.Range("a65536").End(xlUp)
Set LastRow = Range("A" & Rows.Count).End(xlUp)

LastRow.Offset(1, 0).Value = TextBox1.Text
LastRow.Offset(1, 1).Value = TextBox2.Text
LastRow.Offset(1, 2).Value = TextBox3.Text
MsgBox "One record written to Sheet1"
response = MsgBox("Do you want to enter another record?", _
vbYesNo)
If response = vbYes Then
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
TextBox1.SetFocus
Else
Unload Me
End If[/VBA]

simple example attached.