Hi,

First question is what type of combo box do you have? There are 2 types.
When using xl2007 the two types are displayed when you click on Insert on the
Design Ribbon (Form control and ActiveX controls). In pre xl2007 versions,
one is created from a button on the Forms tool bar and the other is created
from a similar button on the Control Tool Box tool bar.

Changes to a combox created from the Forms toolbar only need you to right
click on the combo box and you get a hatched border around the combo box and
a dialog box with some options.

Changes to a combo box created from the Control Tool Box tool bar (ActiveX
control) require you to select the Design Mode first which is a button on the
Control Tool Box bar which looks like a blue set square, pencil and ruler and
then right click the control.

Unfortunately the help files do not do a good job of specifying which type
of control is being referred to.

Regards,

OssieMac