How do I make a ComboBox use a list from another sheet in Excel?

[ndm berry]

I'm trying to make a ComboBox use several different lists from different
worksheets in the same workbook, with little success. If possible I would
like the lists to in alphabetic order regardless of which list they come from.

[Richard Buttrey]

On Mon, 5 Sep 2005 01:25:04 -0700, ndm berry <ndm
[email protected]> wrote:

>I'm trying to make a ComboBox use several different lists from different
>worksheets in the same workbook, with little success. If possible I would
>like the lists to in alphabetic order regardless of which list they come from.


If the lists are never changing, probably the easisest way is to build
a sorted composite list and use this in the RowSource property of the
combo box.

If the lists are dynamic, then you'd need a bit of extra code to first
build the composite list, sort it and apply the new list to the
RowSource property.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

[Dave Peterson]

John Walkenbach shows how to fill a listbox with unique items (and sort it) at:
http://j-walk.com/ss/excel/tips/tip47.htm

You could modify it to loop through all your ranges (and make it a combobox).

ndm berry wrote:
>
> I'm trying to make a ComboBox use several different lists from different
> worksheets in the same workbook, with little success. If possible I would
> like the lists to in alphabetic order regardless of which list they come from.

--

Dave Peterson