Maintain Date Format from Worksheet, onto UserForm

[reberryjr]

My worksheet displays the date correctly, but when the UserForm pulls the date in, the date is not formatted correctly. I've searched this, and other forums and none of the options that I've found are working. Any suggestions?

    'Format(Me.txt_DCStart, "MM/DD/YY") = .Cells(coboDict.Item(Me.cobo_Name.Value), "O").Value
    'Me.txt_DCStart = .Cells(coboDict.Item(Me.cobo_Name.Value), "O").Value = Format("O", "MM/DD/YY")

 

[Paul Ked]

I think it should be

Me.txt_DCStart = Format(.Cells(coboDict.Item(Me.cobo_Name.Value), "O").Value, "MM/DD/YY")

 

[Norie]

To preserve the formatting in the cell use Text.

Me.txt_DCStart = .Cells(coboDict.Item(Me.cobo_Name.Value), "O").Text

 

[reberryjr]

Thank you for the responses! I tried both options and Paul"s response worked!