Mark,

After you create your "option 3" combo box right click on
it and go to properties. Find the
property "ListFillRange" and type the range of cells that
you want to appear in the combo box. That should get you
what your lookin for!

Rob
-----Original Message-----
not sure this belongs in 'programming', but..

I'm interested in using a combobox on a spreadsheet to
easily allow selection of a long list of data items,
which
may be stored on a different sheet.

there seem to be three combo boxes in Excel, which all
act
a little differently... the one from the Forms toolbar,
the one from the Controls Toolbox toolbar, and the one in
the VB forms.

At least here, the one from the Forms toolbar, allows me
to define the source range (on the 'Control' tab of
the 'Format Control' dialog box), but it doesn't actually
work like a CombBox, it works like a list box (won't
allow
freeform input).

The one from the VB form allows me to define the row
source, and allows freeform input... good, but I want it
in the worksheet itself.

The combobox from the 'Controls Toolbox' toolbar allows
freeform input, but there is no 'Control' tab visible on
the 'Format Control' dialog box, and in the properties,
there is no 'RowSource' property.

Can someone tell me how to assign the source data range
to
the the combobox from the 'Controls Toolbos' toolbar?

Thanks.
Mark
.