hyperlink on part of a text contained in a cell

[Cajeto 63]

Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google only.

Thank you.

 

[Dave Peterson]

Excel doesn't support this kind of thing.

But you could cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) and
assign a hyperlink to that rectangle.

 

[Cajeto 63]

Thank you Dave for that fast and easy trick that will work fine.

--


Regards, Cajeto 63.

Excel doesn't support this kind of thing.

But you could cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) and
assign a hyperlink to that rectangle.

 

[Andy Pope]

Hi,

A possible appearance work around would be,
Apply hyperlink to the whole cell. Then edit the cells font attributes.
Remove blue colour and underline. Now edit the cell content and select only
the word Google.
Reapply Blue font with underline.

The whole cell will act as hyperlink but only Google will look like
hyperlink.

Cheers
Andy

 

[DataHog]

Try this routine:

Sub AddCellHyperlink()
' Select cell on the worksheet to place the hyperlink
'
cellcontents = InputBox("Enter Cell Display", "Hyperlink Cell Display", _
Default:=ActiveCell.Value)
If cellcontents = "" Then Exit Sub
ActiveCell.Formula = cellcontents

webaddress = InputBox("Enter Web Address:" & Chr(13) & _
"Example: http://www.google.com", "Hyperlink Address", _
Default:="http://www.google.com/")
If webaddress = "" Then Exit Sub

With Worksheets(1)
.Hyperlinks.Add ActiveCell, webaddress
End With
End Sub

J Knowles