Hi,

YOu can use the format function for example lets say your list contains
dates then use the format in the change event for the combobox

Private Sub ComboBox1_Change()

ComboBox1.Value = Format(ComboBox1.Value, "mm/dd/yy")

End Sub





Cesar Zapata


J Tulk wrote:

Is there any way to format the contents of a combo box? I
am using EXCEL 97. The format of the list has no effect
on the format in the combo box. The combo box doesn't
seem to have any properties except size.