Populating a Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I populate a combo box with a query that filters the distinct items
from a column in a different worksheet?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use VLOOKUP to populate text box on form 8
comboboxes, extracting specific item 7
Cascading Combo Box & Content Filtering 1
How to populate Combo Box ?? 3
Populate combo box, then hide rows that don't match chosen value 1
populate combo box from worksheet 4
Automatically populate combo box. 1
Populating listbox on the basis of Combo box selection. 0

Back
Top