Textbox search and display results in listbox

Hi all,

First let me say I have posted this question on another forum but have not gotten any luck so far...link. I have simplified my file so that only the information needed is included; hopefuly this may clear up some of the confusion and allow me to explain my end goal better.

I have a userform with a textbox, listbox, and commandbutton. The user enters text in the search box, clicks the commandbutton, and the results are displayed in a 3 column listbox. The search is done with wildcards. The column searched for the text entered in the textbox is column B. If a cell under column B contains the text that was searched, the B column cell, corresponding A column and C column cell will be displayed in the listbox in A | B | C order.

I have attached the sample workbook. If the user enters "Radio" the results should be as such.

Allan Radio Broadcasting, HTML, Marketing No
Alston Talk Radio Not Interested
Blankenship Desktop Support, Radio cards Not Interested
Burdick Cross Domain, Radio Broadcasting No
Carter Information System, Radio Tester No

I have tried numerous sample codes and have been stuck on the problem for a week. Any help or code tries is very much appreciated - I would hate to have to scrap the search function because I couldn't figure it out. If anything else needs to be explained please let me know! Thank you all!!

Why have you set your workbook to resize the Excel Window? You should warn people - they may not all realise what has happened.

Try this

Search criteria in TextBox *radio*

paste the filtered range to another sheet, or simply delete the filtered range

Please Login or Register  to view this content.

I was a little rushed earlier, try this

I have since fixed the clear issue and the cell resizing issue. the other 2 are a mystery still

The code does not resize the cells

I've added an error handler in case no results are found & a Clear button

Here's the ne code

Please Login or Register  to view this content.

Hey !


First : thanks a lot for this help. I have been browsing through so many forums before finding your answers !

My little contribution : to make the list update automatically when typing the word or part of it there is 2 modification to make :

1 - change :

Please Login or Register  to view this content.

and instead put :

Please Login or Register  to view this content.

... by doing this : as soon as you type a letter, Excel will do a FilterData and update the list under.(the best would be to have something immune to letter case, upper case, lower case, whatever case)

2 - change the auto filter criteria :

Please Login or Register  to view this content.

and instead put :

Please Login or Register  to view this content.

... by doing this : you can input just a part of the word.

============
... I do have a little request though. Could you comment a bit your code ?
I'm trying to adapt on my own program and I'm blocking a bit on the range definition, resize, specialcells, etc. (since I don't have exactly the same worksheet. I don't start on the second line, I have more columns and my total amount of lines may change).

Many thanks !!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

What would

Please Login or Register  to view this content.

achieve? You can't change a CommandButton

There's not actually such an event

I have it on my excel ...
As soon as I get back on my computer I'll edit this post and add a screenshot.
but, yes: it's working. I did manage to do it.

UPDATE 1 : Ah ! Sorry !! ... I put the change event on the textbox. My bad !
UPDATE 2 : Original message corrected. Sorry for the confusion.

Ask your own question, don't post in other member's posts