filter combobox options

Hello,

I am trying to filter combobox2 based on combobox1 selection. What I would like is when Zak is selected in combobox1, combobox2 only shows values with Zak in the title.

Is this possible?

Thanks

Z

I can't post the workbook but... combobox1 is looking up a rowsource of authors and combobox2 needs to filter that rowsource to show only items that contain Zak.

combobox1 is populated using rowsource property. combobox2 does not yet have a source as I'd like the source to be a filter of combobox1

Thank you romperstomper, however that code just mirrors the option selected in combobox1

I have adapted your code slightly to try and show all the items within a rowsource that contain a specific piece of text.

Please Login or Register  to view this content.

What I would like is for combobox2 to return a list of values that contain whatever is selected in combobox1. Is that possible?

Thanks

Z

That's it!!!!! Thank you I've been trying to do this for about 3 weeks!