troubleshooting Question

Search command button on Excel Userform to return a list of results

Avatar of Katie Dee
Katie Dee asked on
VBAMicrosoft Excel
18 Comments1 Solution1676 ViewsLast Modified:
I have built a userform that has three command buttons - Search, Save and Add New Record, Save and Exit.  I am struggling with the Search function.  The challenge is that there are 33 fields, but only five would be suitable to search by:  Staff Name, Caller First and Last Name, Recipient First and Last name.  Since the records do not have a unique identifier, the end user should be able to search by any of those five fields and get a returned list of matches.  

If the user does not find a result they are looking for, they should be able to "X" down that list and return to the userform.  I need to figure out a way that when they "X" it down, it will have cleared out the search data and display only a blank userform.

If the user clicks on a name in the list of results, it should then open that record with all the associated data into the userform. I'm thinking I should create another Userform just for this function so the code for the Save and Exit Button as well as the Save and Add New Record button will replace the record on the worksheet instead of adding another record to the next blank row.  I have read through every possible code I can find on the web because I'm not a programmer and couldn't possibly figure this out on my own.  I do have the other two buttons working though, thanks to the web.

Can anyone help get me started on the Search button programming so that it returns the results in a list?  I'm thinking there is code out there that will tell me how to get the record to display on the userform as well as a code to "X" down the list of results.
Katie Dee

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros