excel macro - make cell text into hyperlinks

[chomp99]

Hi,

I have a column of keywords in Excel that I would like to convert to hyperlinks with a macro. I would like the hyperlink url to be concatenated with a variable equal to the keyword in the cell. I would also like any spaces in the words of the cell to be translated to "+" sings in the url. Can anyone help? This seems like an easy macro but I don't know VBA programming to do this yet:

Example:
eye candy
candy

Turns to hyperlinked words
eye candy (

http://www.example.com?variable=eye+candy)

candy (

http://www.example.com?variable=candy

THANKS!!
chomp99

 

[SkipVought]

Hi,

Start by turning on your macro recorder and manually inserting a hyperlink.

The look at your reccorded code and post back if you need help.

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[chomp99]

I used the macro recorder. I would have to find a way to alter the code to add the cell word into the url:

Sub Macro1()

Range("B87").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"

http://www.example.com?var=",

TextToDisplay:="candy"

End Sub

 

[SkipVought]

Sub Macro1()

    with ActiveCell
       ActiveSheet.Hyperlinks.Add _
         Anchor:=ActiveCell, _
         Address:= "[URL unfurl="true"]http://www.example.com?var="[/URL] & .Value, _
         TextToDisplay:=.Value
    end with
End Sub

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]