Filter userform combobox based on specific criteria

[jprlimey]

Any suggestions on how i can filter the data loaded into combobox on userform to specific value/text as shown below. The userform does load but the data is not filtered. Any help would be appreciated

Thanks

Please Login or Register  to view this content.

[Norie]

myRng is still the same after the filter.

If you only want to show the results of the filter you'll need to extract the visible cells from myRng and then add them one by one using AddItem.

[jprlimey]

Norie,

Thanks for your response.

would the following extract the visible cells?

Please Login or Register  to view this content.

I'm not sure on what needs to be done with AddItem?

[jprlimey]

It would appear that i have posted the same question twice yesterday. After posting the first question yesterday i couldn't see my post, hence shortly after i re-posted the same question albeit with a slightly different title, my apologies to all. Below is the link.

[jprlimey]

I can now filter the range with the specified criteria. However i now get a run-time error 381 (Could not get the List property. Invalid property array index) when i select a record to load in to the main user form. any thoughts?

Please Login or Register  to view this content.

[Norie]

If the result of the filter is a non-contiguous range you can't use List like that, you need to use AddItem as I suggested.

Please Login or Register  to view this content.