Thread: Dates as Numbers in Combo Box
View Single Post
  #4  
Old 09-19-2008, 05:45 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 and still when selecting the dates in the Combo Box they appear as a number format

Code:
Private Sub cboGetDate_Change()
    Dim GetDate As Date
    If GetDate = CDate(cboGetDate.Value) Then
           cboGetDate.Value = Format(CDate(cboGetDate.Value), "dd/mm/yyyy")
        Else
    End If
End Sub
I cant see where am going wrong?
Reply With Quote