I have a database in Excel with a Userform. For the reported date, when the user enters the 'reported date' it transfers successfully to the Excel database. However, when a record is called up again (for editing) in the UserForm, the date appears as a serial number. I've searched everywhere to find appropriate vba code that will "force" the entry in the reported date text field to display as a date when the UserForm is opened. Since this is a project for work, I am unable to download any date picker for this project.
My project is ALMOST complete - except for this dilemma. Can anyone help guide me on what code is needed, and where that code needs to be inserted? I'm extremely new to using VBA and creating UserForms, so this is particularly frustrating for me.
Thanks!
Bookmarks