I've managed to Frankenstein a user form that actually works rather well, what I am missing and can't seem to get working is a search box that will list results in a list box and then when an item is clicked in the list box, the details are populated in the provided area. The search box would only search for the Jack ID (column B), match any part of the ID, so you don't have to type the entire ID to find a match or matches. Your help would be greatly appreciated.
Bookmarks