Entering Date for User Form.

[Livin404]

Greetings,

I'm trying to finish a User Form. Everything is fine but I'm trying to get the date on the User form to read the date in a "DD MMM YY" format. The worksheet destination is in the correct format. It is when I enter the date in the "USER Form", I'm running into problems. The current code I'm using in the Module

.Cells(iRow, 1) = [Text ,("DD-MM-YY")]

. When I enter a date in the "User Form" I get a value error. I need to control the date that ends up in my database.

Any advice would be great.
Thank you,

 

[Livin404]

Greetings,

I'm trying to finish a User Form. Everything is fine but I'm trying to get the date on the User form to read the date in a "DD MMM YY" format. The worksheet destination is in the correct format. It is when I enter the date in the "USER Form", I'm running into problems. The current code I'm using in the Module

.Cells(iRow, 1) = [Text ,("DD-MM-YY")]

. When I enter a date in the "User Form" I get a value error. I need to control the date that ends up in my database.

Any advice would be great.
Thank you,

I also tried

 .Cells(iRow, 1) = frmForm.Txtdate = "DD MMM YY"

which I had no luck with.