LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Make a hyperlink, by placing data in a cell inside

Say you have an excel file with stocks on it..
in the first list..

MSFT News
WIN.to News
JBOH News
AMTD News

all in the first row.. I want to make.... a link say
www.stockquotes.com/bla/bla/symbol= (cell) /bla/bla.htm
So I can see the news.

how would I make it auto fill one of the stocks above.. and be blue
clickable?

In query you can make it so it refers to the link as what evers in cel
say A1 , it'll place it in the link. But I dont want the info to be
pulled to the excel page, I want to be taken to the browser to see the
news.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting data from two cells to make a hyperlink Gene[_2_] Excel Discussion (Misc queries) 2 July 7th 07 10:30 PM
make the cell hyperlink to any name within it hoyt New Users to Excel 2 July 18th 06 03:23 PM
How make hyperlink refer to cell content rather than cell address. Omunene Excel Discussion (Misc queries) 3 March 2nd 06 01:07 AM
How do I make a picture stay inside a cell? Davdi Keltner Excel Discussion (Misc queries) 2 October 7th 05 08:19 PM
Placing the target cell after a hyperlink is executed Jon Rathbun Excel Programming 2 July 31st 03 11:32 PM


All times are GMT +1. The time now is 01:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"