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!
Bookmarks