View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Try:

Private Sub ComboBox1_Change()
With ComboBox1
.Value = Format(.Value, "mm/dd/yy")
End With
End Sub

---
While in design mode, right-click on the combobox and
select "View Code".

HTH
Jason
Atlanta, GA

-----Original Message-----
I have created a combo box with list of dates attached,

but when I sellect a
date from the list, it appears as a number (not date

format). How do I change
this?

Thanks,
.