Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
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
. 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'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
Excel Formula:
.Cells(iRow, 1) = [Text ,("DD-MM-YY")]
Any advice would be great.
Thank you,