Consulting

Results 1 to 5 of 5

Thread: SearchWord

  1. #1

    SearchWord

    I had downloaded a module from VBAX submitted by "mdmackillop" that allows you to search for a key word in Excel. The search results are returned to a newly created worksheet named "FindWord". The results are listed and hyperlinks added pointing back to the cell(s) the text appears in. The process works fine except for the hyperlinks. The keyword(s) results are in blue and underlined as if they have been assigned a hyperlink, but when you click on the link a error pops up with "Reference is not valid." Can anyone suggest what adjustments are needed in order for the hyperlinks to work.

    Thank you very much for your assistance.

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    This should be the kb entry:
    http://vbaexpress.com/kb/getarticle.php?kb_id=780

    Are you trying to use it as an addin or are you trying to customize it to use in your workbook as mentioned in item 5 of the how to use section of the entry?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3

    SearchWord - Hyperlinks

    As-is. No mods whatsoever. Do you have a email address that I can forward the XLS file?

    Thanks,
    -Hank

  4. #4
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    post it here Hank. After you click on post reply scroll down below your message and look for manage attachments.

    You may have to post a couple of extra posts as I believe you need five posts before you can attach files.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  5. #5

    SearchWord

    Please see attached XLS. You can execute SearchWord via button on top.

    Thanks.

Posting Permissions

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