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

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.

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.