Search duplicates, choose one in userform

[BarefootPaul]

I have been working on this for a bit on my own and trying to figure out the best way to approach it, but I am going in circles, so here goes.

I have a database of folks with some unique identifiers, but I want users to be able to search/lookup by last name, which obviously may not be unique. I also want them to be able to search by the unique identifiers, but I can do that with Vlookup no sweat.

Since I am trying to fully limit the end user's access to the worksheets, I have a userform. I would like the end user to be able to type part or all of a last name and then hit a search button. If the name is unique then I want to fill a few txtboxes on the form (I know how to do this), add some other information and then hit another button to find that record and add the new content to some cells to the right of that record.

If the name is not unique, I would like a listbox (is this the best way) to pop-up with all of the matching records so that the user can choose the correct one, which will then fill the txtboxes and append the new information to the correct record.

Does that make sense? I have looked at Index and Match, but am having trouble translating it to the userform.

I am using Excel 2010, with the ws name as Clients and the data in tblClients.

Thanks to all for feedback/direction.

 

[BarefootPaul]

Anyone?

 

[wrightyrx7]

BUMP this would be very useful for a userform im going to make. Anyone??

 

[BarefootPaul]

I figured it out, check out this thread: http://www.mrexcel.com/forum/showthread.php?t=615011

Let me know if any of it doesn't make sense, but I think the essential code is all there.

Paul

 

[wrightyrx7]

Thanks for this Paul would it be possible to get a copy of your Workbook? (less the data obviously) Just so i can have a look at your userform.

Regards
Chris