How to Make a Search Box in Excel with Interactive and Dynamic Buttons | Filter with Macro

[@wertyghjkl-fc3dx]

Thank you for posting this. Bit of a learning curve but fun getting this to work in a manner that would be helpful. First time with macros. Really appreciate showing how to find the developer option!

[@halukakalin1368]

It’s very easy and useful way, thanks.

[@LIMHERST]

This is great - I have a question, I have one column that is a formula of concatenating cells together (I've done this for an easier search - I will only have to search within one column rather than each individual one as I have the same information in columns) however, it does not seem to work if the column consist of formulas - are you able to find a solution?

[@mustafadelmonte9413]

Just what i was looking for..thanks bro. But i have idea. To clear the tex in the search column. Delete all the text before stoping the record.so once clear is press all the text in the filter area will be cleared and the table will return to nomal..

[@JopaExcel]

Good idea! With your idea the header will always be clean. Thank you 🙏👍

[@wertyghjkl-fc3dx]

Do have a question though for macros...you labeled yours 'filter', which I believe is because of what you wrote in the button so it simply matches. Is that correct? or did you do that because it is filtering the data? I did search in my button so in the macros pop up did the same.

[@ishelou]

Hi, THANK YOU FOR THIS VIDEO. I WANT KNOW IF THE SEARCH CAN DO BY ANY CARECTER IN THE CELL !.. THANK YOU.