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

Mark,

Instead of RowSource it's the ListFillRange for the controls combobox. I
never noticed this before I read your question, but it seems to be the same
thing.

hth,

Doug

"mark" wrote in 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

Hi Mark,

Check out the LinkedCell & ListFillRange properties of the ComboBox in the
Properties window. They should give you what you're looking for.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


mark wrote:
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

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
.

Instead of RowSource it's the ListFillRange for the
controls combobox. I
never noticed this before I read your question, but it
seems to be the same
thing.


Thanks. That makes sense. I had tried that, but I must
have tried it incorrectly, because it is working now.

It appears that if you try to input a range name that
doesn't exist into the ListFillRange property, it just
ignores it... comes back blank after you hit enter.

Perhaps I did that at first.

Either way, it is working now.

Thanks.