Enclosed is a workbook sample, I need to show the date value in the Combobox formated as "mm/dd/yyyy". I used Format as shown bellow:
Code: Select all
If IsDate(.Value) Then .Value = Format(ComboBox1.Value, "mm/dd/yyyy")
Regards,
Chuck
Code: Select all
If IsDate(.Value) Then .Value = Format(ComboBox1.Value, "mm/dd/yyyy")