Friday, February 27, 2015

Upgrading excel text filter

The following is a VBA programming concept for implementing a text filter for MS Excel sheets. The text filter has the following features:

- Uses ActiveX controls
- Instantaneous search and update
- Search for cells that contain words even if they are not complete
- Search for words regardless the case of the word: upper case, lower case, or mixed case
- Search for words regardless the order of them
- Search words are assumed to be space delimited
- Extra spaces are not considered

This is a demonstration captures:


After searching for word "shady":


After searching for "Mohsen Shad":



Here is the code below (sorry for adding it as a capture because I don't know how export it with colored keywords):


Good appetite :)