Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating a Combo Box
How can I populate a combo box with a query that filters the distinct items
from a column in a different worksheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating a Combo Box
Use the advanced filter to build a unique list in another location and use
that. create a collection and populate it from your entries, then put those in the listbox. See John Walkenbach's sample code: http://j-walk.com/ss/excel/tips/tip47.htm Filling a ListBox With Unique Items -- Regards, Tom Ogilvy "Bryan" wrote in message ... How can I populate a combo box with a query that filters the distinct items from a column in a different worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating the combo from worksheets | Excel Programming | |||
problem with populating a combo box on a userform | Excel Programming | |||
Populating combo boxes | Excel Programming | |||
Populating combo box with a function | Excel Programming | |||
Populating Combo Boxes | Excel Programming |