Use InPut in Hyperlink

[gj]

Trying to put InPut answer into hyperlink

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

 

[Tom Ogilvy]

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

 

[gj]

Trying to put InPut answer into hyperlink

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

don't work Tom
gj

 

[Tom Ogilvy]

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

End Sub

Worked fine for me. When I entered a valid symbol, it opened that as a web
page.

--
Regards,
Tom Ogilvy

 

[Dave Peterson]

I think I'd try it once more.

If it doesn't work, post your code and what you typed into the inputbox.

 

[Steve Franks]

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