Sri,
Please find the attached file. With All your Requirements...
Please Drag n drop all the modules and forms and also copy the code from thisdocument to your files thisdocument.
I have assigned Hot keys
Crtl+7 to "SelectAllKeywords" procedure which will provide you option to select mapping file and then it will highlight all the Keywords (one instance for one cell) present in mapping file.
Crtl+0 to "ShowCheckListForm" which will show you related Checklist Items of selected keyword.
Crtl+= to "SelectNextKeyword" this will select Next keyword. Let say you have selected "Country" keyword and if in list "Animal" is the next keyword then it will select the next occurrence of Animal.
Crtl+- to "SelectNextInstanceofSameKeyword" this will select Next occurrence of same keyword. Let say you have selected "Country" keyword then it will select next occurance of "Country" keyword.
Crtl+9 to "SelectonSelection" procedure which will remove all the selection and select only occurrence of selected keyword. Like if you selected "Country" then it will remove all selection and will show you all occurances of country.
Crtl+8 to "Remove All" this will remove all Highlighted keywords.
I believe this serves all your requirement.
Thanks
Rahul Singh
Bookmarks