Thread: How do I make a ComboBox use a list from another sheet in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Richard Buttrey Richard Buttrey is offline
external usenet poster
  
Posts: 296
Default How do I make a ComboBox use a list from another sheet in Excel?
On Mon, 5 Sep 2005 01:25:04 -0700, ndm berry <ndm
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
__________________________
Reply With QuoteReply With Quote