Thanks a lot .. Will wait for you to get back
Thanks a lot .. Will wait for you to get back
Hello Excel fox have you made the rough draft as yet ? Please let me know.Thanks !
Hi Sri,
Excel Fox is quite busy..
and He handover your work to me..
Please find the attached word macro file with solution.
Crtl+7 key is used to select mapping file and select all the keywords
Crtl+8 is used to Remove all selection
an individual keyword selection occur when select from list box.
Note: Listbox get filled once you open correct file using Crtl+7.
Please let me know if you face any issue.
Thanks
Rahul Singh
Hello Rahul thanks for your work but i think my requirements have been misunderstood I shall make my requirements more clear in the next reply
1. When the first macro is run it should identify all the KEYWORDS in the document using the excel file as an input.
2. Each keyword has its own dropdown listbox which populates the list of CHECKLISTED words for that keyword. For example if i click on the keyword fruit then the dropdown listbox for this keyword fruit should have apple orange grapes banana as the checklisted words. The listbox for each keyword should only populate when i click on the keyword. So for this you should match checklisted words in sheet 2 for each keyword in sheet 1 from the excel file first.
3. Then on a hot key press event i should be able to move from one keyword to the other. Upon clicking the keyword the listbox for that keyword should populate.
Note: If the same keyword repeats itself more than once in the same row then the keyword should be highlighted only once not twice. But if it occurs again in a different row then it should be highlighted.
If there are 20 highlighted words then there will be 20 listboxes. Each might contain 4, 5 .. 13 checklisted words depending on how many checklisted words are there for that keyword.
If you are still not clear please let me know. Thanks Rahul
Last edited by Sri; 07-21-2012 at 11:00 PM.
so sri, when all keywords will be highlighted thn how many listbox you want show.
If you want show all then where to place 20 list boxes.....?
Bookmarks