Sylvain

Use this concept

Dim lrow As Long

lrow = Cells(Rows.COUNT, "A").End(xlUp).Offset(1, 0).Row
Cells(lrow,1) = Combobox1.value ' column A data
Cells(lrow,2) = Textbox1.Text ' column B data

where the numbers represent columns 1 (A) and 2 (B).
lrow represents the first blank row at the bottom of your data.
Expand to suit your needs.
You can put the code in the module that opens the form, or place it in the
event macro of the form elements.

You can even code for Option buttons and Check boxes.

steve

"Sylvain" wrote in message
...
Hi all,

is there a method in VB to add a new record to an excel
data base while using my own form?. ( basically in the
same fassion as the builtin data form from the Data menu )

Thanks

Sylvain.