Problem with date in user form

  • Thread starter Thread starter Ivo_69
  • Start date Start date
I

Ivo_69

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
 
Ivo,

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

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Ranges with Gaps - Finding Corresponding Maximum 0
Access Sub form opens before the main form in MS Access 0
Excel Help with dates 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel VBA 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
Help needed 0
Peculiar Date problem 4

Back
Top