Variable into Hyperlink

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon - 12 Jan 2007 16:30 GMT

How do you put a variable into a hyperlink address?

Stock = TextBox1.Text
ActiveWorkbook.FollowHyperlink
Address:="http://finance.yahoo.com/q?s=IBM

I want the variable "Stock" in the address, not "IBM"

Thank you

Gordon

Reply to this Message

Dave Peterson - 12 Jan 2007 16:53 GMT

I'd try:

Dim Stock as string
Stock = TextBox1.Text
ActiveWorkbook.FollowHyperlink _
Address:="http://finance.yahoo.com/q?s=" & stock

> How do you put a variable into a hyperlink address?
>
[quoted text clipped - 7 lines]
>
> Gordon

Signature

Dave Peterson

Reply to this Message