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 72749](https://chandoo.org/forum/data/attachments/72/72841-ec0a9a2062c3e692a9b6161ed240ccdc.jpg)
Source,example file adress
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 72749](https://chandoo.org/forum/data/attachments/72/72841-ec0a9a2062c3e692a9b6161ed240ccdc.jpg)
Source,example file adress