Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Web Page
Jim,
Put the following code in the appropriate sheet's code module: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) ThisWorkbook.FollowHyperlink _ Address:="http://finance.yahoo.com/q?s=" & _ Target.Text Cancel = True End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jim Zeeb" <Jim wrote in message ... I want to display a web page using info from a cell when that cell is double clicked. For example, I have a cell with a stock symbol in it ( i.e. MSFT) When I double-click the cell, I want to start IE with the URL: http://finance.yahoo.com/q?s=MSFT I've searched, but found no examples of this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
Excel saved as Htm displaying tabs on web page | Setting up and Configuration of Excel | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Displaying Page Titles For Urls | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) |