View Full Version : Solved: Open a Web Page on Validation
Sir Babydum GBE
07-31-2007, 09:07 AM
Hi
How can I get a specific web page to open up if someone types (or selects) "Yes" in cell I23?
Thanks
Sir BD
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
07-31-2007, 09:19 AM
That's excellent - cheers mate!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.