Ivo,

Use DateValue to convert the text to a date, like:

DataBaseCell.Value = DateValue(me.TextBox1.Text)

HTH,
Bernie
MS Excel MVP


"Ivo_69" wrote in message
...
Hello,
I create user form for database that contain dates in one column.
But when I fill user form it copy the date in the database column like text
and the formulas related to this cells dosen't work.The cells in the column
are formated like dates.
How to solve this problem?

Ivo