Still working on it. A lot more complicated than anticipated.
Still working on it. A lot more complicated than anticipated.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
No problem. Please take your time. Thanks !
Hello excel fox how far have you gotten with the code ? Please let me know
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.....?
Rahul I will see the listbox with the checklisted words only for the keyword that i click. The listbox shall dropdown where the keyword occurs in the document not as a common listbox.
Hi Sri,
Please find attached word file with asked requirement.
shortcut Keys:
Crtl+7 : To Open excel file and select all key words
Crtl+8 : To remove all the selection
Crtl+9 : To Highlight Selected keyword from document
if keyword exists then it will fill the next listbox with related checklist words
also provided a list box with all the keywords in excel file. on selection of item in this listbox it will act same as Crtl+9
Thanks
Rahul Singh
I was trying to check the macro but i was not able to run it on another word document . I added three listbox 1 and listbox 12 and listbox 11 but when i run the macro it says error debug program and highlights listbox11 in the code. How do i run it on other word documents.. Cnrtl +9 only works the other shortcut keys dont seem to work.
Bookmarks