Variable into Hyperlink

[Gordon]

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

 

[Dave Peterson]

I'd try:

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