+ Reply to Thread
Results 1 to 5 of 5

Hyperlink text in a cell

  1. #1
    Registered User
    Join Date
    02-12-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    32

    Hyperlink text in a cell

    Hi

    I use this piece of code to hyperlink a text in a cell.

    Please Login or Register  to view this content.
    first question:
    if the cell contains text as - "www.yahoo.com" the Sub convert it into hyperlink that points to local file. only if the text include "http://www.yahoo.com" it works fine.

    anyway to bypass it ?


    second question:
    if the cell contains text as - "www.yahoo.com www.google.com" - is there a way to convert both addresses to hyperlink ?

    thanks for any help
    Last edited by gonen; 02-12-2009 at 10:23 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Hyperlink text in a cell

    Please wrap your code in CODE tags (edit your post, highlight the VBA and click the # symbol)

    Please Login or Register  to view this content.
    I don't know of a way to have multiple hyperlinks in one cell but the above would append the URL to include http:// if required... won't fix bad url's though.

  3. #3
    Registered User
    Join Date
    02-12-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Hyperlink text in a cell

    thanks !

    in WORD - you can have two hyperlinks in table cell...

    hope to find an answer here.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Hyperlink text in a cell

    Me too because it will be a triumph!

    A hyperlink is assigned to a cell ... given you have only one cell you have only one hyperlink... you would have to embed object from Word or use multiple controls within the cell... see: http://www.ozgrid.com/forum/showthread.php?t=104425 for more info.

  5. #5
    Registered User
    Join Date
    02-12-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Hyperlink text in a cell

    many thanks !!!!!!!!!!!!!!!!!!!!!!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1