Thread: Use InPut in Hyperlink
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gj[_2_] gj[_2_] is offline
external usenet poster
  
Posts: 9
Default Use InPut in Hyperlink
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