You can't do this with a forms combobox, you can with a control toolbox
combobox which has a font property.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"J Tulk" wrote in message
...
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.
.