Date Format ActiveX TextBox

[AndrewKent]

Hi there,

I have a TextBox linked to a cell on a spreadsheet via VBA coding. The cell is formatted "dd/mm/yyyy" and when I load the value of this cell into the text box (which is 02/11/2010) with the following lines:

        JML_Dashboard.txtJML_StartDate.Value = Worksheets("Employee Data").Range("M" & lngActiveRow & "").Value
        JML_Dashboard.txtJML_StartDate.Value = Format(JML_Dashboard.txtJML_StartDate.Value, "dd/mm/yyyy")

It ALWAYS shows the date as 11/02/2010. What am I doing wrong?

Andy

 

[AndrewKent]

SOLVED:

        JML_Dashboard.txtJML_StartDate.Value = Worksheets("Employee Data").Range("M" & lngActiveRow & "").Text
        JML_Dashboard.txtJML_StartDate.Value = Format(JML_Dashboard.txtJML_StartDate.Value, "dd/mm/yyyy")