The formatting I'm trying to do is to make the contents of
the box have a higher point size (font size = 18 to 30)
and to be bold. I tried variations on the code you show
below but I'm not good enough to figure out thewording
that is needed.

-----Original Message-----
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.
.