A userform for checking phone numbers displays the possible matches in a listbox. Unlike the filtered range I was using before this method doesn't clear the listbox when there is no longer a match but errors leaving the last matches in the listbox.
Is there a way to catch this error? I assume its because the nwnumlst array is empty when there is no longer a match.
Any help appreciated
Please Login or Register to view this content.
Bookmarks