Good Afternoon,
A friend of mine has asked for some help on a project which is going to use Excel. I do a lot of work in Excel, but this project is needing some things that I do not routinely do. I would like to solicit some ideas from the forum.
The project concept is simple. Have a user enter a search element, find the element, and then display the data in a user form. I have no problem coding the search and putting the results of the search on the user form. My problem is the search element may not be unique and there could be multiple matches. When this occurs we would like to be able cycle through each item until all of them have been displayed or we might want to display a list of matches and allow the user to choose which one to display.
I am sure this is a very simple process, but seeing I don’t know how to do and I’m sure there are quite a few of you that do I thought I would ask for help instead of frustrating myself. I just need so general information to get started and I can take it from there.
In my attached sample, I might want to search on the Institution “ICC” which has multiple entries. How would I carve the list down to just ICC and then cycle through that list putting the information on a user form. Or how would I present a list and allow the user to select what they want to display on the form.
The actual data spans many columns and that is why we want to put it on a user form to make it more useful to the user.
Thanks in advance for your help.
Bookmarks