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 :)
- 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 :)
No comments:
Post a Comment