Is it possible to create VB form to search Excel file and return results?
Posted on 2009-07-02
I have an excel file composed of 3 sheets (could be combined into one) that is being used for donated inventory tracking. It details the names of the donors, and then in other cells goes on to include info about the title of the item donated, the date it was donated, and so on.
Is it possible to make a VB form that could search the excel file by first and/or last name and display returned matches (partial or whole), along with the corresponding data from the other cells?
Example: Search for "willis" returns
Name: Willis, Bruce
Title: Bruno album
Also, if there's an easier way to accomplish this, with or without VB, please speak up. I'm a total newb at VB, but it's the only tool I have at my disposal that I have any experience with.