30. VBA Tips - Fast Search
Do you have a large amount of data held in an Excel Spreadsheet ?
- If so, you will be well aware how difficult it is to find things
This tip demonstrates a way using VBA that enables you to search through your data really quickly, and helps you to find what you are looking for.
What I have written is a demo I used for searching through flight details.
- You type the airport in the box, and the code loops through the records, and returns the relevant airports.
Here's a screen shot of our data in Excel:
As you type, the code looks in the DB for the string, and displays the results where the string "Lon" is found:
- Open the sheet, and type "LONDON" in the box for a demo
If you would like ExcelExperts.com to implement this for your Excel based system, please contact us to Request a quote
Training Video on Fast Search: