How do I make a field with email addresses hyper?

[Christopher Glenn]

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.

 

[jamescox]

There may be a better way, but this works:

Select (click on or use the arrow keys to go to) the cell, press F2 an
then press the Enter key

Hope this helps.... :Bg

 

[Gord Dibben]

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

 

[Christopher Glenn]

Thanks Gord, but I think I'll go with the newbie method. The F2+Enter
also automatically moves to the next cell down in the same row, so
it's quick work to do them.

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.

 

[jamescox]

Just for future reference, I think Gord's method is meant to be used b
first selecting _all_ the cells that have the email address text in the
and then running the macro once.

The intersection described in

For Each Cell In Intersect(Selection
Selection.SpecialCells(xlConstants, xlTextValues))

would pick up all cells of interest in a group of selected cells, eve
if some of the selected cells had numbers or cell formulas in the
(that's done with the xlConstants and xlTextValue parameters to th
SpecialCells method)..

 

[Gord Dibben]

Sorry

I should have explained that select all the pertinent cells first then run
the macro.


Gord

Thanks Gord, but I think I'll go with the newbie method. The F2+Enter
also automatically moves to the next cell down in the same row, so
it's quick work to do them.

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub


Gord Dibben MS Excel MVP

[Using Excel 2002, SP3.]

I reviewed the Excel help file and could not find the answer. When I
type in a new email address, as per my options, it makes it hot.

But when I pasted in a set of raw text data, including email
addresses, they were not made hot. If I select the cells and click on
the Insert Hyperlink button, it does not make entries in that cell or
column hot. Instead it wants to link that cell or column to something
else it wants me to specify. How do I make a cell entry 'hot,' after
the fact? I also have a column of Facebook pages I need to make hot
as well.

Thank-you.