Thread: Dates as Numbers in Combo Box
View Single Post
  #8  
Old 09-19-2008, 06:20 AM
JezLisle JezLisle is offline
Forum Contributor
  
Join Date: 06 Jun 2008
Location: Manchester
MS Office Version:MS Office 2003
Posts: 143
JezLisle is becoming part of the community
I have tried this code below and it seems to work like it should...

Code:
Private Sub cboGetDate_Change()
    MyDate = Format(cboGetDate.Value, "dd/mm/yyyy")
    cboGetDate.Value = Format(MyDate, "dd/mm/yyyy")
End Sub
Reply With Quote