Excel UserForm changing date format on Edit

  • I have a simple employee data entry user form with an edit feature. When a row is selected and the edit button is clicked it repopulates the user form so it can be edited and saved. I have an issue with the date column coming back in a different format other than date. It seems to be changing to a general format and giving me a general number other than the date. Does one have any suggestions on how I can get the date to come back correctly?

  • Hello,

    In your cmdEdit_Click() procedure ... you could test following :

    1. Me.txtEDate.Value = Format(Me.lstDatabase.List(Me.lstDatabase.ListIndex, 4), "dd/mm/yy")

    Hope this will help


    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Carim

    Changed the title of the thread from “Excell UserForm changing date format on Edit” to “Excel UserForm changing date format on Edit”.