Thread: Use InPut in Hyperlink
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Use InPut in Hyperlink
If it should look like http://finance.yahoo.com/q?s=abc

and MyInput contains abc then

Dim MyInput
MyInput=InputBox("Enter Stock Symbol")
ActiveWorkbook.FollowHyperlink _
Address:="http://finance.yahoo.com/q?s=" & MyInput



--
Regards,
Tom Ogilvy


"gj" wrote in message
oups.com...
Trying to put InPut answer into hyperlink

Dim MyInput
MyInput=InputBox("Enter Stock Symbol")
ActiveWorkbook.FollowHyperlink _
Address:="http://finance.yahoo.com/q?s=MyInput



Reply With QuoteReply With Quote