Thread: Dates as Numbers in Combo Box
View Single Post
  #1  
Old 09-18-2008, 05:19 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
Dates as Numbers in Combo Box


I have the same problem as thread,

http://www.excelforum.com/excel-prog...ml#post1969271

When I fill the Combo Box it shows as a date in the list for selecting in the Combo Box. Once I select the Date I want it then changes back t its number format. I have tried using the code below and still no joy, where am I going wrong?

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