Dachande11
Registered User.
- Local time
- Today, 08:00
- Joined
- May 1, 2001
- Messages
- 41
Hello,
I have been trying to find a way of searching through some records in Excel (test data in Data worksheet), and then displaying the results of the search in a list box.
Whilst searching various sources on the internet I came across a partial solution which is shown on attached workbook. Basically as I type into a text box, 2 list boxes display results. The first list box works fine, as it simply goes to the appropriate line based on what I type into the text box.
Its Listbox2 that is causing me to pull my hair out. I am trying to get this list box to only display the records (and associated columns) based on search criteria. At the moment it only shows the first column. I would like it to display the other 2 columns as well.
Im afraid im just not clued up enough with regards to Excel and VBA.
Any help would be greatly appreciated.
Thanks
Mark
I have been trying to find a way of searching through some records in Excel (test data in Data worksheet), and then displaying the results of the search in a list box.
Whilst searching various sources on the internet I came across a partial solution which is shown on attached workbook. Basically as I type into a text box, 2 list boxes display results. The first list box works fine, as it simply goes to the appropriate line based on what I type into the text box.
Its Listbox2 that is causing me to pull my hair out. I am trying to get this list box to only display the records (and associated columns) based on search criteria. At the moment it only shows the first column. I would like it to display the other 2 columns as well.
Im afraid im just not clued up enough with regards to Excel and VBA.
Any help would be greatly appreciated.
Thanks
Mark
