• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel AutoFilter According to Textbox Value

kadrleyn

Member
Good to have you chandoo.org

I created a template to filter on the worksheet based on the searched value (letters, numbers or other characters) in textbox , using the VBA Find and AutoFilter methods.
The filtered cells are listed on the worksheet, the number of filtered cells is informed to the user by msgbox.

I wanted to share it ,I hope it benefits to users.

72749

Source,example file adress
 
Back
Top