code for creating form for logging phone call details

[grant8oy]

Hi...I need to create a form to use in work so when people call I can log each call and input the data and save to a spreadsheet...I havn't used visual basic for a few years so need some help...I took what I could from a tutorial and edited it but I think ive balls'd it up somewhere...If anyone can help me I would appreciate it greatly.

Ive uploaded a screen shot of what im trying to code here.

http://img399.imageshack.us/img399/4...albasicur9.jpg


Code:

Private Sub cmdClearForm_Click()

Call UserForm_Initialize

End Sub



Private Sub cmdOk_Click()
ActiveWorkbook.Sheets("Course Bookings").Activate
Range("A1").Select

Do

If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If

Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = txtName.Value
ActiveCell.Offset(0, 1) = txtPhone.Value
ActiveCell.Offset(0, 2) = cboDepartment.Value
End If

Range("A1").Select
End Sub


Private Sub cmdButt_Click()
Sub OpenCourseBookingForm()
frmCourseBooking.Show
End Sub


Private Sub UserForm_Initialize()
txtName.Value = ""
txtPhone.Value = ""
With cboDepartment
.AddItem "Sales"

.AddItem "Finance"

.AddItem "Technical"

.AddItem "Stores"

.AddItem "Dispatch"
End With
cboDepartment.Value = ""
End With
txtCall.Value = ""
End With

refNature.Value = ""
End Sub

[grant8oy]

Can anyone help me please??

[Mechroneal]

Hi...I need to create a form to use in work so when people call I can log each call and input the data and save to a spreadsheet...I havn't used visual basic for a few years so need some help...I took what I could from a tutorial and edited it but I think ive balls'd it up somewhere...If anyone can help me I would appreciate it greatly.

Ive uploaded a screen shot of what im trying to code here.

http://img399.imageshack.us/img399/4...albasicur9.jpg


Code:

WHat's it doing? (the sign of a truly lazy programmer)

[royUK]

Take a look at the DatabaseForm example here:

http://www.excel-it.com/vba_examples.htm