Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
I want to have a hyperlink automaticallly inserted into a cell when that cell
has a specific piece of text typed into it, is it possible in Excel? CG1954 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
You don't provide too much information but you could build on this
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub If Target.Address = "$A$1" Then If Target.Value = 123 Then Target.Hyperlinks.Add Target, "http://www.google.co.uk/ig?hl=en" End If End If End Sub Mike "CG1954" wrote: I want to have a hyperlink automaticallly inserted into a cell when that cell has a specific piece of text typed into it, is it possible in Excel? CG1954 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|