ComboBox - VBA - Unique Views...

**Strat94** · 07-11-2009, 02:32 AM

Hi Guys,

I've been struggling with this for a while, I've used an advanced filter upuntil now but it's not working.

I have a column that is updated several times a day, I need to be able to view that list in a userform combo box and that box to be able to react like an autofilter list. I've tried the advanced filter thing but as th elist is contantly updated it makes this very hard to handle as I have to set macros to compile the list and then delete it once it's been used. Is there a way I can set vba code so the ComboBox populates unique fields, sorted AZ and removed the blanks without using the advanced filter..??

I've been researching this for ages and can't find a solution... Please help.

Regards

Jason

**royUK** · 07-11-2009, 03:07 AM

This example has a ListBox that can be Filtered

FilterForm.zip

**Strat94** · 07-11-2009, 11:14 AM

Thanks Roy, certainly looks interesting... Trust that if I dig deep enough within the code I will actually find what I'm looking for here... Thanks for your help.

**Krishnakumar** · 07-11-2009, 01:39 PM

Hi,

Try this

Please Login or Register  to view this content.

HTH

**Strat94** · 07-12-2009, 09:13 AM

Couldn't get that to work....

To make sure I am doing this right, say for example that my list will appear between B10:B251, do I put those two values in the value boxes and leave the row source option blank..??

**Krishnakumar** · 07-12-2009, 11:28 AM

Hi,

Just replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

and leave the rowsource property blank.

HTH

**royUK** · 07-12-2009, 02:04 PM

Strat94, have a good look at the example & post back with specific questions

**Strat94** · 07-13-2009, 07:24 AM

OK, thanks guys.

I don't understand which part of the code populates each combo box and then entres the info into the list box.

The ideal is to take a list between B10:B251, on a sheet called Week 1, stuff that list into a combo box on a user form, filter out the duplicates and put it in alphabetical order and once that is done, the user selects one and all the matching of that selection is displayed in the list box.

I can work out some of the stuff you provided Roy but I get confused as there are 5 combo boxes all working together in that example and I can't seperate them.

krishnakumar, I'm sorry, but yours doesn't work at all. I am placing the code in the view code bit on the combobox on the form, is that the right place..??

Sorry to be so vague guys.

J