Populate a listbox with data that is shared in two other listboxes

[travreed7]

Good morning,

I have an excel userform that acts as a database to research details of zip codes. In ListBox1, I have every zip code in the US that spans multiple counties listed upon initializing the userform. In listbox4 I have a small sample of zip codes that a user can type into the worksheet that also populates when initialized. I want to then have Listbox5 list any zip codes that are listed in both listbox1 and listbox 4 so that the user can type in a sample of zips that they are researching and be able to identify which ones span over multiple counties.

Basically I need a code that can make this happen: If a value(s) shows up in both Listbox1 and Listbox4, then that value(s) shows up in listbox5.

Any help would be greatly appreciated.

Thanks!

[JasperD]

Try this (works on activex control listboxes)

Please Login or Register  to view this content.

[travreed7]

Do you happen to have a code that will do it in basic listboxes. ActiveX controls are not trusted on my system and I do not have the rights to change it.

thanks.

[JasperD]

If you use form control listboxes, you probably have a listfillrange connected to them, correct?
If so, I'd use a helper column
something like this:

Please Login or Register  to view this content.

I'm not sure if this will work, cause have no computer here and am not used to using form controls.