wabtrainer
IS-IT--Management
I have a tool in Access which allows me to search a table for a string and display the results in a listbox.
I would like to do something similar in Excel, but have little knowledge of spreadsheets.
In Access:
I use a txtbox and the user enters the text.
As each character is added, the listbox updates to build the string using an sql query, so if the ser is looking for "Hardware" by typing H the lisbox displays all strings begining with H. When he enters a, all text begining with Ha is displayed. So the whole string may not need to be typed to get the required results. He can the click on a line in the listbox and a new form is opened (filtered on that string) for more information.
In Excel:
There are two columns that hold long paragraphs ot text and I want the user to enter a string they want to search for (probaly using a userform?) and the results to be displayed in a listbox. The user should then select the items in the list they want displayed and the worksheet suould then display the whole rows that contain the selections.
Has anyone done anything similar, before I lock myself away for days trying to get this off the ground.
Any help will be appreciated. I can give the code for my access form if necessary, but it works a little different than excel (i think??).
If you want to be a bear:
Be a Grizzly!
I would like to do something similar in Excel, but have little knowledge of spreadsheets.
In Access:
I use a txtbox and the user enters the text.
As each character is added, the listbox updates to build the string using an sql query, so if the ser is looking for "Hardware" by typing H the lisbox displays all strings begining with H. When he enters a, all text begining with Ha is displayed. So the whole string may not need to be typed to get the required results. He can the click on a line in the listbox and a new form is opened (filtered on that string) for more information.
In Excel:
There are two columns that hold long paragraphs ot text and I want the user to enter a string they want to search for (probaly using a userform?) and the results to be displayed in a listbox. The user should then select the items in the list they want displayed and the worksheet suould then display the whole rows that contain the selections.
Has anyone done anything similar, before I lock myself away for days trying to get this off the ground.
Any help will be appreciated. I can give the code for my access form if necessary, but it works a little different than excel (i think??).
If you want to be a bear:
Be a Grizzly!
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
