Solved: Open a Web Page on Validation

[Sir Babydum GBE]

Hi

How can I get a specific web page to open up if someone types (or selects) "Yes" in cell I23?

Thanks

Sir BD

[rory]

Right-click the sheet tab, choose View Code, then paste this in and change the URL as needed:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("I23")) Is Nothing Then Exit Sub
If UCase$(Range("I23").Value) = "YES" Then ThisWorkbook.FollowHyperlink "http://www.microsoft.com"
End Sub


HTH
Rory

[Sir Babydum GBE]

That's excellent - cheers mate!

[rory]

No worries. :)
Rory