multiple search and search bar

[poobs_away]

This will be my second post here. Is there a way in VBA to make a filter function that has a keyword search bar attatched? If there is I imagine it would be something that types the word into the keyword being filtered as you type in the search bar and then runs the macro when you hit the "search" button.

If anyone has a code for this could you also put comments in it so that I can have a better understanding of what the code is doing, if that's not too much to ask. Thanks.

 

[poobs_away]

Also the search bar was just a thought. If anyone can think of another way to do this without the search bar, but still make it accessible to other people who will eventually be using the sheet this macro is on, please tell. I only say search bar because I know VBA can make buttons, so I'm hoping it can make this as well. My excel version is 2010, if you need that information.

I also forgot to explain that I need this to have the ability to choose which column you're searching in. For example, in the worksheet I'm working with, column A is a from column and column C is a to column. The filter would need to be able to find all the keywords in just column A or just column C. Thank you.

 

[VoG]

I think that you are talking about a UserForm with a TextBox to Search For, a TextBox to enter the column to search and a Search button. Am I right?

 

[poobs_away]

yeah that sound about right. Sorry, I'm fairly new to VBA so I don't really know what it can and can't do, and I haven't found a way by just googling it yet.

 

[VoG]

This is about as clear as I can describe it but I may have missed some stages. Try like this

Open Your workbook


Press ALT + F11

Insert > UserForm

Click on the UserForm - You should see a dialog with various objects

Click on abl to insert a textbox

Draw out on the form

repeat to add a second textbox & draw out on the form

Click the Command Button icon (looks like a button)

Do not (at this stage) rename any of the objects that you have created.

Click on ListBox1 and set its ControlSource to A1:a10


Click on ListBox2 and set its ControlSource to "A,B" etc.

Clickon the command button, right click

''''''


and so on...

 

[poobs_away]

Cool, I looked up userform and how to make one and it looks easy enough for me to do. I guess my problem was I wasn't using the right terminology. Thanks man!

 

[poobs_away]

Oh, sweet. Thanks! This makes my life a lot easier.