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 |
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 |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com