Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 36

Thread: 40$ Word Macro Highlight Keywords And Maps Checklisted Words In A Listbox

  1. #11
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    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

  2. #12
    Junior Member
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0
    No problem. Please take your time. Thanks !

  3. #13
    Junior Member
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0
    Hello excel fox how far have you gotten with the code ? Please let me know

  4. #14
    Member littleiitin's Avatar
    Join Date
    Aug 2011
    Posts
    90
    Rep Power
    13

    Word Macro to Highlight Keywords.

    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
    Attached Files Attached Files

  5. #15
    Junior Member
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0
    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

  6. #16
    Junior Member
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0
    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.

  7. #17
    Member littleiitin's Avatar
    Join Date
    Aug 2011
    Posts
    90
    Rep Power
    13
    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.....?

  8. #18
    Junior Member
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0
    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.

  9. #19
    Member littleiitin's Avatar
    Join Date
    Aug 2011
    Posts
    90
    Rep Power
    13
    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
    Attached Files Attached Files

  10. #20
    Junior Member
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0
    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.

Similar Threads

  1. Replies: 7
    Last Post: 08-24-2015, 10:58 PM
  2. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. Replies: 1
    Last Post: 10-16-2012, 01:53 PM
  4. Replies: 4
    Last Post: 08-14-2012, 03:17 AM
  5. Replies: 7
    Last Post: 06-23-2012, 07:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •