| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use InPut in Hyperlink
gj wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use InPut in Hyperlink
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 "gj" wrote in message oups.com... gj wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use InPut in Hyperlink
Try:
MyInput = "http://finance.yahoo.com/q?s=" & InputBox("Enter Stock Symbol") ActiveWorkbook.FollowHyperlink Address:=MyInput -- Steve Franks "Tom Ogilvy" wrote: 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 "gj" wrote in message oups.com... gj wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use InPut in Hyperlink
I think I'd try it once more.
If it doesn't work, post your code and what you typed into the inputbox. gj wrote: gj wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| How do I input email addresses in Excel without the hyperlink, | Excel Discussion (Misc queries) | |||
| hyperlink based on user's input | Excel Programming | |||
| hyperlink based on user's input | Excel Worksheet Functions | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
![gj[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
